Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Totals

Hi Team,
I created one table with geo's and Actuals, Flash for that geo's. I want to hide one geo (Other) but totals should not get effect. Below table I want to hide Other from geo the moment I hide that Flash value is changing because of that negative value. Kindly help to fix this issue. If I remove any geo on that table totals should not get effect.

 

Need Help

2 Replies

  • VijayP's avatar
    VijayP
    Community Champion
    3 years ago

    Anonymous 

    Make sure you are using measures to achieve this table!

    Sample measure for Flash($M) shoule be
    if(Hasonevalue(geography), Flash($M) , calculate(flash($M),all())

    and the select the record of negatives right click and select Exclude

    Total will be for all values but individual values will be different

     

    But you need to make sure you have notified to the end user that you have done this adjustment else the totals are confusing