I have couple of pivot columns and then a total columns
->Pivots: e.g Country A , Country B… &
->Total : All Countries
->each has couple of measures.
I have applied conditional formatting on one measure ‘P’
#1 Issue: In the visualization edit-> series-> formatting rules, I need to select “include totals” only then the conditional formatting applies on that measure ‘P’ in total columns( All countries)
#2 Issue: But it is also getting applied on the ALL column’s( including pivot columns) grand totals too… Why? Any solution?