Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

compare more years in a PivotTable

Hello to all...
I have a problem with doing an analysis with previous years.
I have a pivot table as in the example qwv and I would need to create two tables as in the xls file.
I tried several solutions but I could not solve. Surely it seems a simple example might help others users.
Thanks so much

1 Solution

Accepted Solutions
sunny_talwar

Check out the attached

Capture.PNG

View solution in original post

4 Replies
sunny_talwar

Check out the attached

Capture.PNG

Not applicable
Author

perfect ... the colors I added them on "visual signals". But if I select the years 2015 and 2016 it appears to me only the column of the year 2016 however it would be correct to appear by information relating to 2014

do you have any idea?.

sunny_talwar

I did not understand your question, can you may be rephrase it?

Not applicable
Author

sorry I answered too quickly .... Okay as you did!