Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community! First time posting here, so bear with me please. I suspect my issue is not an easy one, but hopeful I can at least gain some insight, and I'll do my best to explain...
I am trying to present in a dashboard the # of projects for several businesses across various stages of product development. For one business, in one of the stages, there are no projects, so the result should be "0". But when making the selections in the list boxes (Business and Stage), when I choose the Business, the Stage list box knows that the stage I am looking to present on has 0 results and so it does not let me select it. As a result, I cannot get a "0" to show up.
Is there a formula or some kind of statement that can be added to the load file to account for this? Any input would be greatly appreciated.
Thank you in advance,
JAlex