10 Replies Latest reply: Dec 9, 2016 9:48 AM by Sunny Talwar RSS

    % of the column total in Pivot table

    Monica Chhabra

      Hi All,

       

      I have a pivot table with column called Product Category and row called EE Segment.  I have created a measure that counts # of Clients by using:  count(distinct([Client ID])).  This measure gives me # of clients in each Product Category by EE Segment. I also have totals by EE Segment in Pivot table. Now I want to create a measure in the pivot table where I can get % for each Product.  i.e #of clients in each Product Category by EE segment/total clients in each EE segment.

      Please see attached picture of the pivot table.

      I would appreciate if I can get ideas of how to create the measure

       

      Thanks and Regards,

      Monica