Formatting Pivot Tables in Excel 2007

[ProgEvalJAA]

I want to format a pivot table appropriately such that when I have two entries falling underneath the same group both lines say the group number.

What I Have Now:

Sum of Amount
Group Name Total
1 Julie 5
2 Jon 10
Leo 9
3 Tim 5
4 Duane 8
Travis 7

How I would like the table to look:

Sum of Amount
Group Name Total
1 Julie 5
2 Jon 10
2 Leo 9
3 Tim 5
4 Duane 8
4 Travis 7

See the numbers 2 and 4 repeating for each entry.

 

[SkipVought]

Hi,

Pivot Tables don't REPORT that way. It is a REPORT.

If you want a standard table, as you illustrate, use MS Query, External Data Source --> YOUR WORKBOOK.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]