Pivot Table Issue

[rahulsingh12]

Hi I have a pivot table with 2 columns

ID1 Id2 and I do a count of it in expression.

ID2 comes after ID1 so  what I want is that if I rollup ID2 upto ID1 then it should count only ID1 occurrence and if I expand it till ID2 then should count only ID2 value.

E.g

They have respective count as

ID1-50

ID2-40

Case1:

            Count

ID1      50

Case2:

                         Count

ID1       ID2          40

Regards,

[balar025]

You have to use Dimensionality()or Aggr function based on your dimension.

Still if you have confusion, Please provide your sample application

Regards,

Ravi