| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Show % between two columns in a pivottable
Hi everybody,
I have a data table which looks something like Col A Col B Col C Customer Year Sales CustomerA 2006 10000 CustomerA 2007 12000 CustomerB 2006 8000 CustomerB 2007 6000 .... I would like to create a pivottable that looks like 2006 2007 Index Customer A 10000 12000 120% Customer B 8000 6000 75% .... But I don't now how to have Excel calculate the index. As far as I know calculated items/fields only work with data from different columns. Any help would be greatly appreciated. DQ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Only show certain columns | Excel Worksheet Functions | |||
| Cell formatting in worksheet doesn't show in pivottable | Excel Discussion (Misc queries) | |||
| PivotTable - show top items | New Users to Excel | |||
| Print Pivottable - show all selected items in page filter | Excel Discussion (Misc queries) | |||
| pivottable - show all not appearing | Excel Worksheet Functions | |||
Threaded Mode
