Show total by dimension

[varunreddy]

Hi All,

I have a pivot table and I am trying to display the distinct count at the end of the dimension.

Current Report:

In the above screen Shot, I am trying to calculate distinct Number by Type and Name either by using the straight or pivot table as shown below in the "Expected Output".

Expected Output:

Attaching the source file and the QVD. Can anyone please help me with this?

[vishsaggi · Accepted solution]

try this in your expr and in presentation tab enable Show partial sums check box.

= IF(Dimensionality() = 2, Count(DISTINCT Number), Severity)

[varunreddy]

Hi Nagaraju,

Thanks for your quick response

Cheers,

Varun