7 Replies Latest reply: Jan 23, 2014 10:00 AM by Jairaj Singh RSS

    how to get first nth date in pivot table?

    Jairaj Singh

      HI ALL,

      How I'll get the first nth date in Pivot table.

      For example I have below sample date:

      Date                    Sales

      01-01-2014          100

      02-01-2014          101

      03-01-2014          100  

      04-01-2014          100 

      ---------------          ------    and so on.

      Now I want to display only first 3 date and their respective sales in pivot table.

      Please help on this.

      Thanks in advance