October 6, 2017 at 8:41 am
I have a report request to add a parent group to a pivot table that is the rank of the group by the total sales measure, to this effect:
Total Sales Group Category Total Sales
----------------- -------- -----------
Over 1 Million Toys $2,500,000
Socks $1,750,000
Shoes $1,200,000
Under 1 Millon Dresses $ 900,000
Hats $ 490,000
It appears that the "Total Sales Group" has to be a calculated column, not a measure, so that it can be a row group in the Excel Pivot Table.
"Total Sales" is a complex measure, not just a simple sum, and based on child table data aggregations, it would make for a pretty complex formula for a calculated column.
What's the best method for accomplishing something like this with SSAS tabular?
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply