Macro to extract totals from Pivot if value is >0

**shekar goud** · 05-05-2009, 05:25 AM

Hi,

I have an pivot from which i need the SUB TOTALS in Column J if the value is > 0 i just need an macro for this could someone please help.

Iam attaching an sample file.

Regards,
Shekar.

**shekar goud** · 05-05-2009, 11:13 AM

Hi,

Could someone please help on the above.

Regards,
Shekar.

**shekar goud** · 05-06-2009, 10:10 AM

Hi Team,

could someone please advise how to use Getpivotdata and would that forumale helps me to get the SUB Totals in a new column if the SUB Total is > 0.

Regards,
Shekar.