I have one big table in my dashboard, In which I am showing some granular level data.
I am showing grand total for my KPI's. i have one product filter. In which i have 3 values say for ex, P1,p2,p3.
I want to show grand total for P1 and P2 only and not for P3.
I can do this using multiple sheets and use hide and show, but I don't want to do it.