See enclosed file
I have a pivot table when i have a "PRevious" and "Current" value. I want to add to the pivot table a "Change" and "%Change" value.......but i am not sure how to do this.
Can someone help?
See enclosed file
I have a pivot table when i have a "PRevious" and "Current" value. I want to add to the pivot table a "Change" and "%Change" value.......but i am not sure how to do this.
Can someone help?
Hello my friend
You have to add Calculated Field
When you click on PivotTable, shows 2 contextual Tabs (Options and Design).
Click on Options and search for the button Fields, Itens & Sets.
Click on it and search for Calculated Fields
There you can add any kind of simple equations... you can't add functions like IF or SUM... but simple mathematical signs.
I just checked your file... the problem is that the data isn't correctly organized
It should be one Header for each number with Current and Previous
Something like: Current Hdr1 | Previous Hdr1 | Current Hdr2 | Previous Hdr2 | ...
This way you can use calculated fields to do your job
thanks. i will take a look at what you said in more detail .............
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks