2 Replies Latest reply: Jan 20, 2014 6:03 AM by Harshal Sonone RSS

    Sum Formula Pivot Table

      Trying to create a pivot table with 3 functions: Quarter, Competitor and Segment.

       

      Trying to display data as Segment>Competitor Quarter Wise.

       

      Expressions: Total Sales, Market Share.

       

      The table is not showing values as per different segment. Its showing the total amount. What formula should i use that the values are shown as per segments.