1 Reply Latest reply: Apr 18, 2013 2:58 AM by Kaushik Solanki RSS

    Seperate total Values

      Hi All,

       

      I'm currently having problems seperating total values on my pivot chart.

       

      MonthSegmentAmt
      Oct 20788814.93
      OctA20788814.93
      OctB20788814.93
      OctC20788814.93
      OctD20788814.93
      OctE20788814.93
      OctF20788814.93
      Oct-20788814.93

       

       

      MonthSegmentAmt
      Nov 19838230.06
      NovA19838230.06
      NovB19838230.06
      NovC19838230.06
      NovD19838230.06
      NovE19838230.06
      NovF19838230.06
      Nov-19838230.06



       

       

       

       

      Now, When I select both MONTH.

       

       

      MonthSegmentAmt
      Oct
      40627044.99
      OctA40627044.99
      OctB40627044.99
      OctC40627044.99
      OctD40627044.99
      OctE40627044.99
      OctF40627044.99
      Oct-40627044.99
      Nov
      40627044.99
      NovA40627044.99
      NovB40627044.99
      NovC40627044.99
      NovD40627044.99
      NovE40627044.99
      NovF40627044.99
      Nov-40627044.99

       

       

       

      It totals up Oct & Nov. IS there any way I can seperate the values?

      I am using the total in the expression

       

      Thanks