Forum Discussion
alicebotteri
8 years agoFrequent Visitor
Conditional Hierarchy Measure
Hi Guys,
I need to make a table with a hierarchy like TOTAL COUNTRY --> REGION --> SUBREGION .
The filter is on Region but I have to keep fix the first row and show always the TOTAL COUNTRY.
(Now when I'm filtering TOTAL COUNTRY is equal to REGION)
Any idea how to do that ?
TOTAL COUNTRY 10000
REGION 500
SUBREGION 100
Thanks in advance
Alice
1 Reply
- v-huizhn-msftMicrosoft Employee
Hi alicebotteri,
Please create sample table and list expected result for further analysis.
Best Regards,
Angelia