Pivot Rows and calculations

[David_Wong]

This post says the solution is to use the “in” function. I tried it and it seems to work:

Apply PRE_FILTER impact to only few columns - PRE_FILTER Enigma

Yes, I have a multiple value selection for Group label use case. This won’t work because I have alot of values under group label and creating fields for each is not feasible and it is a multi select option too. Please let me know if there exists a workaround for this.

First you have to use parameters for your Country and Year filters. Then rewrite the calculated fields as follows:

Month Total =
sumOver(ifelse(in(Year, ${Year}) AND in(Country, ${Country}), Value, 0), [Month], PRE_FILTER)

Oct Total =
sumOver(ifelse(Month = “Oct” AND in(Year, ${Year}) AND in(Country, ${Country}), Value, 0), , PRE_FILTER)