Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Here is attached data and view of table
Entire table is being calculated by : sum(amounts * rate)
However do I make a certain row not be affected this expression and just display value as is ?
Entire table is calculated. One row should just show the amount as is.
So, in your example, you want Orange to always show the same number regardless of the selection, but everything else should change? May be this
Sum({<[Line Des] += {'Orange'}>}Amount * Rate)
Or this
Sum({$+1<[Line Des] = {'Orange'}>}Amount)
Sorry that is not it.
I have a complicated roll up by level filter requirement. It should be
Filter Level 1 : sum ( Amount * Rate) for the whole table except row 'Orange' ( display as is)
Filter Level 2 : sum ( Amount * Rate) for (Dim1 + Dim 2) but because of auto sum function at level 2 row 'Orange' adds no matter what.
Any ideas ?
What exactly is Level here?
It 's a group filter extension and levels are assigned by variables. Vfilter =1 and so on
So Level1 - has a entity dimension and level2 has another dimension that rolls up into Level 1
All I see is this
And I see reference of entity or any other dimension. I am not sure I can follow your requirement. Unless you are able to provide a sample where we can see all of this, I am not sure how to help you.
Best,
Sunny