• 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


  • 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


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 .



Well-Known Member
Add a column to your source data:
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.


Last edited by a moderator: