Hello. If I have a column in a pivot table that shows "sum of" how can I add a column to the right that shows % of prior value. Obviously I can just write in formulas but I was wondering if I could do this within the pivot table.
Hello. If I have a column in a pivot table that shows "sum of" how can I add a column to the right that shows % of prior value. Obviously I can just write in formulas but I was wondering if I could do this within the pivot table.
there are a bunch of '% of' options if you right click a field and choose 'show values as'
Josie
if at first you don't succeed try doing it the way your wife told you to
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks