pivot table calculation

In my pivot table, I created two columns using Show Values As: % of Column Total. One is Dollar Share and the other is Dollar Share YA. How would I calculate the difference between the two columns and have it appear in a separate column titled, Dollar Share Change? Since I calculated them using...

Hi so i will try to explain this the best i can, When i create a pivot chart it doesn't plot the values that are in the pivot table. i have a data set of two variables (different groups of universities) and then years 2007-2017 in a pivot table with values of student numbers. I have selected...

I've got a dataset that lists records of resolved tickets by date and agent name (as well as a few other criteria). I created a pivot table that has the agent names in the row field and the resolution dates in the column field so I have a daily count of number of resolved calls by agent as well...

Hi All! My end goal is trying to do some price/volume sales analysis (Actuals vs budget) on a pivot table. The fields I have are semi transactional in a sense and are in the simplified table below: <tbody> Key Product Units Sales Sales per/unit Actuals Wand A 10 50 5 Actuals Wand A 12...

Hello In my pivot table I have a sum field (counts the total of a field where the response is 1 for yes and 0 for no) and the count of another field which will basically count all records. I was hoping to add a calculated field to give me the % i.e. how many yes out of the total. I've searched...

Hi I have a simple pivot that looks like this: Sum of hours and max of budget are in the values box in the pivot table. When I try to use the formula builder to calculate the variance = 'max of budget'-'Sum of hours' I am getting an error message.How do I write this formula so it works...