Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Good lord I didn't know that existed thanks.