2 Replies Latest reply on Oct 31, 2016 9:30 PM by Ashish Chaudhari

    Calculate distinct sum of Pivoted values

    Jiji GE

      Hi Guys,

       

      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: