Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody ,
I have to solve the following situation:
I have a pivot table with 2 dimensions. Next, there are 2 expressions.
The first one calculates the value according to Dim1 and Dim2.
The second should calculate the total of all values of Dim1, but relating only to Dim2.
I am doing this in a set analysis (Exp2):
sum( {$<Dim1=>} total <Dim2> Value)
but in that way, I am excluding the possibility the pivot to be shrinked to the selection, when the user select Dim1.
In ther words, the pivot is always expanded trough Dim1, which is not a desired result.
Here is a simple example of what I get now selecting Dim1
and an example of what I need:
So, my question is: What is the correct approah to have this calculation in Exp2 and in the same time to allow the selection in Dim1?
Thank you in advance!
Thank you er.mohit,but unfortunately it does not work.
sum( {$<Dim1=, dim2=>} Value)
can you share sample application?