Pivot table filter calculated field

[ILoveElvis]

Hello,

I have table of gift date, gift amount, gift type

I have a pivot table with date grouped by year and month in rows
I have counted the gift amount, to get number of gifts per date. I've summed the gift amount to get sum of gifts by date.
Now I have to get the count of gifts =$0, the percent of $0 gifts, so count of $0 gifts/count of gifts *100 by date and the avg gift amount by date NOT including the $0 gifts.

I can't seem to figure out the last 3 fields, though it should be easy. Any help would be appreciated.

 

[bschwartz]

You can obtain all of that information, just not all at once.

For instance, to get Avg of Gift Amount >0, have Gift Date in Row Labels, Average of Gift Amount in Values, and Gift Amount again in Report filter, and filter out 0 values.

To get Count of Gifts =0, Have Gift Date in Row Labels, Count of Gift Amount in Values and again in Report Filter. Filter by 0.

For percentage of gifts = 0, put Gift Date in Row Labels, Count of Gift Date in Values, and Gift Amount again in Column Labels. Go to Show values as, on the Options tab, and select % of Row Total.