Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Current 2010 Profit (based on any filter selection)
Sum({<Yr={'2010'}>} Profit)
I want to calculate 2010 Profit IRREGARDLESS of current Channel filter selection.
Sum({<Yr={'2010'}, Channel=>} Profit)
Question - Would my above coding do the trick (igore Channel filter selection)?
Is there better way of writing this code basically ignore ANY filter selection, except for Yr={'2010'} that I specified in the set analysis.
Your help is much appreciated!
sure if you do
Sum({1<Yr={'2010'}>} Profit)
It will ignore all selections.
I'm stuck on % of total.
In a bar chart, I have ProductGroup as dimension, and the following as expression.
Sum({<LOB={HOTEL,PKGHOTEL}>} TXN)
I would like to create another expression, which is calculating the total, IRREGARDLESS or ProductGroup.
Keep in mind, ProductGroup is the dimension slicer in this chart. Is it possible to accomplish this?
Or do I have to create a separate chart to calculate the percentage? If so, what would the set expression look like?
Your help is much appreciated!
Hi
The TOTAL qualifier is used to override dimensions. Use something like
Sum({<LOB={HOTEL,PKGHOTEL}>} TOTAL TXN)
You can also selectively override dimensions using TOTAL <dim1, dim2> where the dimension fields not inside the angle brackets are ignored
Hope that helps
Jonathan
Hi Jonathan,
This worked for me, however, I'm wondering how to limit the dimensions (within the angle brackets) to set values? I am interested in a total, but with certain dimensional fields excluded. Thanks in advance for your help.