4 Replies Latest reply: May 12, 2014 10:59 AM by Srikanth P RSS

    How to Roll in Quarter?

    Neena Bhattarai

      I have four quarters. In the first quarter I have the months Sep, Oct, Nov, 2nd quarter: Dec, Jan, Feb and so on...

      I have the data in a pivot table and would like to have each quarter up to date. Currently I have last years data for January and February showing and would only like 2014 data's to show. How would I accomplish this? I have separated each quarter into 4 pivot tables. Currently I am using this to separate each quarter: =If(MATCH([Month],'Sep','Oct','Nov'),[Month])