Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Display total value based on Hierarchy slicer selection

I have a hierarchy table and would like to display total based on what level the slicer is selected.     If all Level 3 (Division) checkboxes selected, display sum of Level 2 (BU) total acro...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Maggie I'm not sure if you read my post fully. Look at the example and the slicing selection. I know how to do a basic agg based on slicer selection. This is more complex.  There are three totals (Group, BU and Division)  I have gotten other feedback and I was able to get part of the solution working. Below are some examples:

     

    1.  If Audit, SPU, YAD selected, display sum of (Audit, SPU, YAD) (Division Total)

    2.  If 7JB and F8C selected, display sum of (7jb and f8c) - BU Total value (Note** This is NOT the sum of all children under that BU)

    3.  If OC9 selected and Audit selected, display sum of (DIM, TIF and Audit)