Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi team,
if( vSelectedDimension='Customer' ,[Customer], if( vSelectedDimensionr='Region' ,[Region] ))
Sum({<[vDynamicDimension={"=Sum([discount])>=1000"} >}sales) as measure
you can't do this with set analysis because you MUST specify field name on the left side of equal sign, you can't use functions or variables instead.
you can do something like below:
sum( Aggr( if( sum([discount])>=1000, sum(sales) ), $(vDynamicDimension) ) )
we Can use the variables for the field name in SET Analysis.
i have been using like that , can you try like below :
sum({<$(vMyVar)={'C'}>}Sales)
I am trying that also but still i am seeing a difference in values
Your syntax seems to be OFF here
"=Sum([discount])>=1000"} >}sales)
it should be
Sum({<[vDynamicDimension={"$(=Sum([discount])>=1000)"} >}sales) as measure