Pivot table totals after every two rows?

[vishsaggi]

Hello All,

Can you please suggest? I need the subtotals in pivot table.

Attached the file.

[sunny_talwar]

May be use the Macro to make it 0 width?

[sunny_talwar]

Something like this:

SUB Squeeze

CALL HideColumn("CH01", 1)

END SUB

PRIVATE SUB HideColumn(ch, n)

SET ch = ActiveDocument.GetSheetObject(ch)

ch.SetPixWidth (n-1), 2

END SUB

[vishsaggi]

This helped. Thanks very much. Probably i will go with my expression which is pretty suffice my requirement.
Thanks a lot Sunny for your time. Appreciate your time.

V.