How NOT to show 0% values in Pivot chart?

Hi Forum,

Using “Data” tab in the attached Excel file, I have created the Pivot 1 in “Pivot” tab.

Then I copied the entire pivot 1 and pasted it in a new place in the same sheet starting from column k (let’s call this “second pivot” for now).

Then I placed the cursor on the second pivot and right clicked, then clicked “show value as” and then clicked “% of row total”.

Likewise I created the “Pivot 2”.

Then I created Pivot Chart 1 and 2.

Q:
In “pivot chart 2”, I want to show the % income of village 1 only for the last 3 months (like in Pivot Chart 1).

Could you please let me know how to do it.
Thanks
Mirisa