Average Calculation for percentage without considering 0 values in between in Pivot Table

[prasademany]

Hi,


I have day wise & product wise profit % in a table. in that I need to take weekly percentage through pivot table. Few days no business / holiday. hence profit % is 0% (zero%). But while calculating average % of row items it's considering blank / 0 valued cells also in pivot table. but I need to skip the zero valued rows in data to calculate average % and show the required average in pivot.

I have attached my requirement.

[josephteh]

Replace the 0% with a text, e.g. "no business" or "holiday" or "-" or "null".