Excel Pivot Tables - Don't group row headings

[JordanCN2]

I have a pivot table like this in Excel 2003:

Q1 Q2 Q3 Q4
Rep Customer
--------------------------------------
DJ | IBM Corp 200 400 200 100
| XYZ Corp 300 500 100 300
| Lotus 600 700 200 200
SV | IBM Corp 100 300 100 100
| Lotus 600 700 200 200

But I need to have it so the pivot table repeats the Rep ID for each line like this.


Q1 Q2 Q3 Q4
Rep Customer
--------------------------------------
DJ IBM Corp 200 400 200 100
DJ XYZ Corp 300 500 100 300
DJ Lotus 600 700 200 200
SV IBM Corp 100 300 100 100
SV Lotus 600 700 200 200

Is this possible?

 

[SkipVought]

hi,

Not in a PT.

You could use a Query, and assuming that your SOURCE DATA is in Sheet2 AND you headings are in ROW 1, and assuming that the numeric field heading is AMOUNT and your date heading is DTE, the SQL is...

TRANSFORM SUM(AMOUNT)

Select Rep, Customer

From [Sheet2$]

Group By Rep, Customer

Pivot iif(Month(DTE)<4,'Q1',iif(Month(DTE)<2,'Q1',iif(Month(DTE)<10,'Q3','Q4')))

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}