7 Replies Latest reply: Aug 2, 2016 7:55 AM by Sunny Talwar RSS

    In Pivot table capture the Sales for only Same period of time

    Rishi Tiwari

      Hi Guys,

       

       

      I have a table with some fields. I have created a pivot table.  In this table I am showing Company,Category,MonthYear and Sum of Sales.

       

       

      My requirement is that I need to Show only those records where MonthYear for Category Names are same.

      Example: For Company Boombastic there are 2 categories:1:  Men's cloth,2:Men's Footwear;

      So I have to track only those Sales for whom Sales has been happened in common period.

      Means I need to capture in chart this result::

       

       

      Company Name       Category        MonthYear         Sales  

      Boombastic         Men's Cloth      01-2008          1611.2

      Boombastic         Men's Cloth      05-2008          1285.85

       

       

      Boombastic         Men's footwear   01-2008          2451.9

      Boombastic         Men's footwear   05-2008          1234.72

       

      Here Periods are same.rest will be ignore.

      Similarly same for all the companies.

      Only Sales for same period for Categories of a company if happens then we have to capture those records.

       

       

       

      Thanks & Regards

      Rishikesh