Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have filter month_quarter which I want exclude from pivot table
The present expression is as below.
Pick(match(dimension, 'RWA'),
Num(sum({<mica={'RWA'},month_quarter=>}.
Used alternate state and grouping still not working please help me with appropriate approach
To calculates the sum of YourMetric where mica is RWA, ignoring any selections made on month_quarter.
Pick(match(dimension, 'RWA'),
Num(sum({<mica={'RWA'}, month_quarter=>} [YourMetric])))
****Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.****
My bad missed to ad my metric
But still the issue remains same