I have this crosstab from a dimensional model:
Month
Country Category Product Group Product Sales
C1 Indoor PG1 P1 100
P2 200
PG2 P3 300
Outdoor PG1 P1 400
By some weird requirement (the user just want to torment me) , he wants this output
Country Product Group Product
C1 PG1 P1 100
P1 400
P2 200
PG2 P3 300
Dimensions:
Country
Category
Product
Product Group
Product
Makes any sense and how to achieve??
The first crosstab was my initial output. A requirement was added (remove Category from the display but compute the sales including Category)
I tried to hide the Category (Box=None) but my output looks like this:
Month
Country Product Group Product Sales
C1 PG1 P1 100
P2 200
PG2 P3 300
PG1 P1 400
which makes sense because Category is still there... so basically how can I calculate Sales by Product by Category but display the hierarchy without the Category