Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
Oct | 2012 | ||
Total Time Spent In A&E | Admitted | 03:00 | 03:12 |
Non Admitted | 03:12 | 03:00 | |
Total Aggregated | 02:29 | 03:00 |
I have attached an example of a qvd, if someone can help me get the column headings as desired?
Many Thanks
Helen
Hi Helen,
I am not understanding you properly that what you want to do. but see attached example, otherwise explain clearly
Regards
- Anil
Hello
I think I have attached the wrong example!
Could you kindly have a look at my newly atteached example please
Kind Regards
Helen
hi where is your example.
- Anil
Hello
The example is now attached in the original question
Thanks for any help
Helen
hi Helen,
See attached attached QVW.
Regards
Anil
Hello
Thank you for this. I should of mentioned that the pivot table always needs to have the titles I.e. Total Treatment time along the left hand side
Any ideas?
Thanks
Helen
Hi
Actually I am not understanding that what you want to do or what you are saying.
Regards
-Anil
Hello
Thank you for this. I should of mentioned that the pivot table always needs to have the titles I.e. Total Treatment time along the left hand side
Any ideas?
Thanks
Helen