• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot table empty cell

Jagan_Deesh

New Member
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 .
 

Attachments

p45cal

Well-Known Member
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.
 

Attachments

Last edited by a moderator:
Top