Mary has attended:
Excel Intermediate course
Excel Advanced course
Pivot Table Sources
Hi
I have pivot table and would like to create another based on the results of the first.
How ca I do this?
RE: Pivot Table Sources
Hi Mary
Thanks for your question
A pivot table must be based on an Excel database. That is a list with column headings and no row titles. A pivot table is not in this format and therefore you cannot base another pivot table on it.
If you could give me some more detail about what analysis you are attempting, I could perhaps give you further guidance.
Regards
Stephen