Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
try this in your expr and in presentation tab enable Show partial sums check box.
= IF(Dimensionality() = 2, Count(DISTINCT Number), Severity)
try this in your expr and in presentation tab enable Show partial sums check box.
= IF(Dimensionality() = 2, Count(DISTINCT Number), Severity)
Hi Nagaraju,
Thanks for your quick response
Cheers,
Varun