Hide Column/Expression in Pivot table

[#1]

Dear all,

Please see below Pivot table...

I want a Variance only for Current Month (Like April-March).

How to hide other months Columns?

I know we can Hide in Straight Table but some what reason I want only in Pivot table.

Please see attached excel and qvw file as sample data.

Regards

Vinay

[#2]

Can u attach the sample QVW file.

[#3]

Ok With Attachments.

[#4]

Please any body can help!!!!

I have tried below Macro but it hide/disable all second expression.

Any Idea to restrict particular month?

SUB EnableExp1 

    SET chart = ActiveDocument.GetSheetObject("CH01") 

    SET cp = chart.GetProperties 

    SET expr = cp.Expressions.Item(1).Item(0).Data.ExpressionData 

    expr.Enable = TRUE 'Enable Second expression 

    chart.SetProperties cp 

END SUB 

SUB DisableExp1 

    SET chart = ActiveDocument.GetSheetObject("CH01") 

    SET cp = chart.GetProperties 

    SET expr = cp.Expressions.Item(1).Item(0).Data.ExpressionData 

    expr.Enable = FALSE 'Disable Second expression 

    chart.SetProperties cp 

END SUB 

[anbu1984]

Replace your variance expression by If(Left(Mnth,3)=Month(Today()),<Your_variance_expression>)

Then Select "Suppress Zero Values" in Presentation.

[#6]

Hi Anbu,

I have done as suggested but I can't get rid of this -(Hyphen). see my expression..

if(Left(Mnth,3)=Month(Today()),sum(Sales)-before(sum(Sales)))

Thanks

Vinay