I am attempting to display the bottom 10 product lines with a combo-bar chart of Capital and Operating Income. I am struggling because I am leading with capital, which is what I want to sort on, but I would like to see the values that are greater than 0 in this specific chart. The bottom 10 for capital include lots of zero capital product lines but the operating income is positive. Is there a way to write a calculation condition that says if capital = 0 and operating income is >0, then display as 0 so I can get to the product lines that have positive capital and operating income?
Thanks so much for all you do.