2 Replies Latest reply: Mar 21, 2013 3:06 AM by David Norton RSS

    Prior Year vs Current Year Pivot

    David Norton

      Hi Everyone,

       

      I'm trying to put together a pivot that's a little different from the norm, and could use some best practice advice.

       

      For this one, I need periods for the Prior Year and Current Year to alternate, and still function with base-year filtering.  So, the header row would look something like this:

       

      Jan-2012     Jan-2013     Feb-2012     Feb-2013     Mar-2012     Mar-2013

       

      One option is to use a straight-table and create dynamic columns, but I'd really rather maintain the flexibility of a pivot for expanding/collapsing, and subtotals.  Also, I've been trying to create an offshoot table from the Calendar table, to serialize this mixed-year layout, but it's not going as smoothly as I'd hoped.

       

      Any ideas or tricks?

       

      Thanks,

      DJ