Looking for advise or best practice for ranking of top 10 companies (out of 100s) for aggregates on a shipping comparitive value (tonnage). Would like to make each of the top 10 companies a column with values broken down by region (rows). I also need a column for a single chosen company (not necessarily top 10), and another column for that company's percentage of market share.
I'd like to utilize our data cube in a matrix, but can't solve how to add the last two columns above. We have the option of using the cube or the transactional db. Any advice is helpful, thanks.
One option would be to use the sort number 1-10 as your grouping key and have your report dataset based on a union of the 1-10 dataset, the 11 extra column dataset, and 12 extra column dataset. Then do a Matrix to line it up.|||Thanks, we'll give this a try.
No comments:
Post a Comment