Only show Item when average is great than 0

[michael_andrews]

I have a report where I have Items with a name, and then each item can have responses for it. What I'm wondering is, is there a way I can only show responses where there was at least one selected? I.e. an item may have the responses a, b, c, and d, but only a and b were ever selected. Right now, I'm trying to show them when their average is > than 0, as it would be, if they were ever selected, but it still shows all of the items. What am I missing. I'm trying this

avg({<ItemScore = {"=Count(ItemScore) > 0"}>}ItemScore)

But it still shows things that have an average of 0.

I attached an image of the report to help explain.

[brian_holborow]

Michael

if I have read your requirement correctly, the simplest way will be just hide zero value in the pivot - you can do this in the properties:

Hope that helps.

Please mark this as helpful / correct if your question has been answered to your satisfaction

Brian

[michael_andrews]

Good lord I didn't know that existed thanks.