Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=if(ySeg='Total',sum({1<ySeg={'S02','S03','S04'},yMonth={'$(=only(yMonth))'}>} yRev), yRev)
Please write the correct statement for this one.
I want to enter the sum of S02,S03,S04 in a grid against the Seg is Total.
Best Regards,
Gaurav Tyagi
ySeg is your dimension and you want to check if your current line is a total line or a detail line? Something like this?
'Total' is just a label, not a dimension value you can check. Use dimensionality() function for this (or secondarydimensionality() with a pivoted dimension), something along these lines:
=if(dimensionality() = 0,sum({1<ySeg={'S02','S03','S04'},yMonth={'$(=only(yMonth))'}>} yRev), yRev)
edit: depending on the number of your dimensions you are calculating (sub-)totals for, you need to adapt the value you check against (i.e. zero in my sample).
Check the HELP for dimensionality() and also check using =dimensionality() as expression in your chart)
Thanks for the reply
'Total' is acctually a dimension.
I already changed my logic but will check this dimensionality function now.
Hi,
You may try like sum(if(......))
else attach some sample file, which will help to solve your prob....
just paste a sample and Explain what u want finally...