How to get 2 or more title headings in pivot table

[helen_pip]

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

[#2]

Hi Helen,

I am not understanding you properly that what you want to do. but see attached example, otherwise explain clearly

Regards

- Anil

[helen_pip]

Hello

I think I have attached the wrong example!

Could you kindly have a look at my newly atteached example please

Kind Regards

Helen

[#4]

hi where is your example.

- Anil

[helen_pip]

Hello

The example is now attached in the original question

Thanks for any help

Helen

[#6]

hi Helen,

See attached attached QVW.

Regards

Anil

[helen_pip]

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

[#8]

Hi

Actually I am not understanding that what you want to do or what you are saying.

Regards

-Anil

[helen_pip]

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