Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to use PivotTable's to work out Variances?

Status
Not open for further replies.

colinfitz

Technical User
Jul 31, 2007
4
GB
Basically I've got a whole load of raw data and I've been able to create a pivot table so it just shows the relevant info I want. The problem is whenever creating the pivot table the variance columns I have turn to the "Count of".

Now I've tried changing it to the other options but isn't getting what I had in the raw data. Basically before, the variance column was diving a column with another column giving me a percentage.

At the end of each section it's suppose to still be a column dividing another one but the pivot tables like to just add up the percentages giving me different numbers then my raw ones.

I'm assuming the answer is in the "% of" option but what I've checked it allows you to divide the column you have with another one and then adds them all up to 100% but I'm working with variances. I also want to be dividing a column with another column putting the results into a third column. Even trying that I still get #NA. Any help anyone could offer would be greatly appreciated. Cheers.
 
Does anyone have any idea how to fix this? Or can you simply not do it in pivottable's? Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top