Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hello,
I have a pivot table problem that I haven't been able to figure out so I could use some help. My simplified example is below but I'm essentially trying to insert three blank columns (or fields) into my pivot table of quarterly data: 1) Adjustments, which is a numeric input 2) Adjusted half year total, which is a sum of pivot data plus "Adjustments" 3) Notes, which will be text. I want these three inserted fields to be a part of my pivot table so that I can get different data cuts. Columns A:C are my current pivot table. How do I insert columns into my pivot table for what I show below as D1:F1? Here's my example: A1 B1 C1 D1 E1 F1 Customer Q1 sales Q2 sales Adjustments Adj Total Notes Thanks in advance, Scott |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
Product Function in Pivot Tables from Multiple Consolidation Range | Excel Worksheet Functions | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) | |||
combining 3 columns of same info for a pivot table | Excel Worksheet Functions |