Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hierarchy Slicer - Return Field Values not Sum

Hi, following is the problem: I would like to display field values in a visual card through the usage of a hierarchy slicer. However, when picking a value from the slicer, the results presented i...
SQLbyoBI's avatar
SQLbyoBI
Icon for Advocate I rankAdvocate I
6 years ago

I suspect your table structure is the problem. If you restructure your table to then I think you will get what you're looking for... more details below

 

GroupDeptAmount

Dept. Group

Dept A50
Dept. GroupDept B50

 

Create a hierarchy on Group and Dept and use that in your slicer.

Create a measure to sum the amount and put that in your card.