Dynamic Grouping and Subtotal percentage

[vaibhavrc09]

I have a scenario

Measure assume : Sum(Sales)

A: Root level : One Value is selected from the dashboard 
                            This is the main total for all further calcs

B: Level 2 : One Value is selected from the dashboard

                       Associated value should be shown.

                       Unassociated should be grouped into Others.

C: Level 3  :  Associated value should be shown.

                        Unassociated should be grouped into Others.

😧 Level 4 : 

                       Associated value should be shown.

                       Unassociated should be grouped into Others.

I have to calculate sum(Sales) and % Total for each level using a pivot table.

Can someone help me on this scenario

[barnabyd]

G'day, this idea is called "Brushing" and I think the best way to do this is with Set Analysis. In the help page, you can find an example expression which gives you what you're looking for ...

sum( {1-$} Sales )

Returns sales for everything excluded by the selection.

The % total would be something like this ...

sum( Sales ) / sum( total Sales )

or

sum( Sales ) / sum( {1} Sales )

I hope this help.

Cheers, Barnaby.