Our user wants to see what customers have not made a purchase in a certain time frame. I have tried show all on the axis options and this seems to mostly work by sorting on the amount to group the zeros together. Have also tried, in case where we have a current year and prior year sorting on the current year amount to gather the zeros together. Are there any other ways to do this?
Thank you
Probably the easiest way to only show customers with values = 0, is combing the "show all" with a filter on your dataview (your amount cube < 0.00000001).
You find more info in the help: Layout Filters