Pivot Table

[qv_testing]

Hi All,

I have Pivot table, i want to display below format,  but don't want use partial sums

Category	Product	sum(Qty)
Nokia	Nokia1	1
	Nokia2	3
	Nokia3	4
		8
Samsung	Sam1	2
	Sam2	5
	Sam3	10
		17

Thanks .............

[Gysbert_Wassenaar]

You can try using the Indent option on the Style tab. I don't think it's possible to align the cell values of the first dimension at the top of the cell instead of the bottom though. That seems to be possible only if you also choose show the subtotals on top (on the Presentation tab). See attached example.

[#3]

If you don't want to use partial sums, just have to uncheck the option of show partial sums for the 'Category' dimension. It's on the presentation tab.

[MayilVahanan]

Hi

PFA

Hope it helps