| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing % Differences From in Pivot Tables
In Excel 2007 (which I LOVE!) I have the following pivot table, and I need to
calculate average, min, max, and stdev in % Diff From columns (see question marks in the example below). % Diff From is calculated between columns Visit 2 and Visit 1. The values I get wrong, how do I do this correctly? Product Subject Visit 1 Visit 2 Product 1 1 -23.24% 2 -15.26% 3 12.32% 4 0.96% 5 7.34% Product 1 Average ? Product 1 Max ? Product 1 Min ? Product 1 StdDev ? Product 2 1 -5.20% 2 21.12% 3 60.76% 4 -52.86% 5 76.00% Product 2 Average ? Product 2 Max ? Product 2 Min ? Product 2 StdDev ? Grand Total Avg ? Grand Total Max ? Grand Total Min ? Grand Total Stdev ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing text in cells for differences | Excel Discussion (Misc queries) | |||
| Compare 2 pivot tables and report differences | Excel Worksheet Functions | |||
| Comparing two workbooks and highlighting the differences | Excel Discussion (Misc queries) | |||
| Comparing 2 pivot tables data using VBA | Excel Worksheet Functions | |||
| Comparing two data ranges for differences. | Excel Discussion (Misc queries) | |||
Threaded Mode
