In year 2010 I have total of 500 and in year 2011 I have total of 510. How do I calculate in Pivot table the difference in %?
In above example I should get as result increase of 2%.
In year 2010 I have total of 500 and in year 2011 I have total of 510. How do I calculate in Pivot table the difference in %?
In above example I should get as result increase of 2%.
Last edited by pansovic; 09-05-2011 at 11:08 PM.
Hi,
We need an example to see more of what you speak.
Or does this help? http://contextures.com/xlPivot10.html
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks