Hi,
How do I stop Excel's Pivot Table from generating a subtotal of each value in the row groups? I just want to leave it blank.
Thanks,
BBM
Hi,
How do I stop Excel's Pivot Table from generating a subtotal of each value in the row groups? I just want to leave it blank.
Thanks,
BBM
Select one of the sub-totals, right-click, and select hide
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Double click on that field
u will see a small form named as PivotTable Field
there on left side u can set subtotal as none
now with respect to your next query to show blank instead of subtotal--
on the same form bottom right side there is button named as Layout.
click that one & check insert blank line after each item
Hope your query will get resolved by this method
Regards,
Anand M. Bohra
Always Mark your Thread as Solved the moment u got acceptable reply (located under Thread tools)
Practice this & save time of others in thinking for unsolved thread