Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to use PivotTable's to work out Variances?
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to "merge" two subtotaled lists and show variances | Excel Worksheet Functions | |||
How do I work with variances when there is a negative number? | Excel Worksheet Functions | |||
Counting dates in multiple work sheets and work books | Excel Discussion (Misc queries) | |||
Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel | |||
Program line when charting variances? | Charts and Charting in Excel |