Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
if have variable which contains if and set analysis and i dont want to change it.
but if i want to add if before the variable - the answer is not correct.
for example - Sales=
$(vMeasure) =if(VAT='NO VAT', sum( {< YEAR = {$(vCurrYear)} >} [TOTAL SALE)],sum( {< YEAR = {$(vCurrYear)} >}[TOTAL SALE AND VAT]))
now i want to show sales for branch 121 all the time (but still without changing $(vMeasure)
Sum({<branch={121}>} aggr ($(vMeasure_CY),[month and year])) - But it doesnt work
How can i do it??
help ![]()
i wish it was the problem ![]()
please share the sample data