8 Replies Latest reply: Oct 23, 2012 6:52 AM by Helen Pippard RSS

    How to get 2 or more title headings in pivot table

    Helen Pippard

      Hello,

       

      I was wondering if you could kindly help me achieve somthing in a pivot table?

       

      I would like to get a pivot table working so the Year and Month appear at the top of the pivot table and the data has been calculated and split between the 2 headings

       

      (Please note that I am attcahing a simplified version of what I am trying to achieve, but I do need a pivot table for the complicated version I am currently building)

       

      What I am trying to achieve is this:

       

      Oct2012
      Total Time Spent In A&E Admitted03:0003:12
      Non Admitted03:1203:00
      Total Aggregated 02:2903:00

       

      I have attached an example of a qvd, if someone can help me get the column headings as desired?

       

      Many Thanks

      Helen