Pivot table empty cell

[Jagan_Deesh]

Dear All,

I have attached one sheet containes pivot table for CY and LY. For last year i have data for 3 months but for Current year i have data for 2 months only.
While creating pivot chart it generating for all pivot values but i need to compare avalible current year data with last year , Pl help me on this .

 

[p45cal]

Add a column to your source data:
=COUNTIFS([Month],B2,[Year],"CY")<>0
which will show TRUE/FALSE
Refresh the pivot then add the new column to the page field of your pivot and filter for TRUE

See attached.