Pivot: Show subtotals but not details

[coxweli]

Hi,

I have searched for a solution for this issue, but haven't found i anywhere yet. I have a list looking like this:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Department1[/TD]
[TD]Employee1[/TD]
[TD]500[/TD]
[/TR]
[TR]
[TD]Department1[/TD]
[TD]Employee2[/TD]
[TD]400[/TD]
[/TR]
[TR]
[TD]Department1[/TD]
[TD]Employee3[/TD]
[TD]650[/TD]
[/TR]
[TR]
[TD]Department2[/TD]
[TD]Employee4[/TD]
[TD]250[/TD]
[/TR]
[TR]
[TD]Department2[/TD]
[TD]Employee5[/TD]
[TD]275[/TD]
[/TR]
[TR]
[TD]Department3[/TD]
[TD]Employee6[/TD]
[TD]350[/TD]
[/TR]
[TR]
[TD]Department3[/TD]
[TD]Employee7[/TD]
[TD]375[/TD]
[/TR]
</tbody>[/TABLE]

I need a pivot that will show me subtotals, but not on employee level:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Department1[/TD]
[TD][/TD]
[TD]1550[/TD]
[/TR]
[TR]
[TD][TABLE="width: 500"]
<tbody>[TR]
[TD]Employee1[/TD]
[/TR]
[TR]
[TD]Employee2[/TD]
[/TR]
[TR]
[TD]Employee3[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Department2[/TD]
[TD][/TD]
[TD]525[/TD]
[/TR]
[TR]
[TD][TABLE="width: 500"]
<tbody>[TR]
[TD]Employee4[/TD]
[/TR]
[TR]
[TD]Employee5[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Department3[/TD]
[TD][/TD]
[TD]725[/TD]
[/TR]
[TR]
[TD][TABLE="width: 500"]
<tbody>[TR]
[TD]Employee6[/TD]
[/TR]
[TR]
[TD]Employee7[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Hope you can help

Thank you

Bjarne

 

[Andrew Poulsom]

Can't you just remove the employees field from the pivot table?

 

[coxweli]

Can't you just remove the employees field from the pivot table?

No, sorry for not mentioning that... I need the pivot to show the employees in each department.
At the moment I am creating a separate table with the employee list, but I hope that I can include it in one table.

 

[danzon]

I don't think it is really possible. You can however use conditional formatting to make that text "invisible" by formatting the text for those lines to match the background colors.