I'm trying to calculate distinct sum of pivoted values by pivoted Names. LOD works fine for unpivoted data but couldn't find a solution for pivoted data. Sample workbook attached.
This is the end result I want to achieve:
Are you looking for a solution like this?
Pivot from a Calculated field
I am trying to understand this. Can you please explain the result for the pivoted Value Names 1 which is 3203 and how it is getting calculated?
Thanks and Regards,
Retrieving data ...