| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create calculated items on pivot table reports?
I have one example pivot table report. In the source worksheet, there is
columns named as Account and Department. When used this data(worksheet) as pivot table source data, on pivot table feilds list there are two feilds created named as Account2 and Department2. I want to know how I can create and use the feilds in pivot table report those have no columns in source data. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PIVOT TABLE - hiding records with CALCULATED item values equal to | Excel Discussion (Misc queries) | |||
| Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
| Totals of calculated field in pivot table give incorrect results | Excel Worksheet Functions | |||
| how do I create a pivot table based on multiple sheets | Excel Discussion (Misc queries) | |||
| pivot table sort entries that don't yet appear in table | Excel Discussion (Misc queries) | |||
Threaded Mode
