Expression should not take into account the selected dimension

[p_andreev]

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!

[p_andreev]

Thank you er.mohit,but unfortunately it does not work.

[#3]

sum( {$<Dim1=, dim2=>}   Value)

[Kushal_Chawda]

can you share sample application?