I want to calculate the sum of a few dimensions in alternate state and over that, i want to complete calculation by choosing one variable from filter pane. My current expression is
=Sum({[State1]<User_Dimension= {'Active'},Value_Dimension = {'Total'},Value_Type={'Combined'},Time_Dimension = {'$(vTimeDimension)'}>} Value_Entry)
=Sum({[State2]<User_Dimension= {'Active'},Value_Dimension = {'Total'},Value_Type={'Combined'},Time_Dimension = {'$(vTimeDimension)'}>} Value_Entry)
and in which state i should keep filter pane.
Please suggest which approach i should to try to execute my expression.
Thank You