Probably it's an easy question, so thank you for your patience in advance.
I have two columns, one with a field (field_1) and the other one with a measure (sum(fileld_2)).
I would like to create a bar chart showing only the field_1 with the measure >0 (there are many field_1 with 0 as measure, and aesthetically I don't like it) .
How can I use the option: Chart - appearance - Y-axis - Number of axis values="Custom" & Maximum number="???formula???"
I think something about: count(distinct {sum(field_2)>0} field_1) but obviously doesn't work that way
