On my graph above, I do not always want to see that fourth bar over, 'Inventory Adjustment'. I want the chart to default to not have it included in there, but once in awhile I will need to see it. Any suggestions of what I should do?
Thank you for your suggestion, but the chart is filtered to just show the top 8 (inventory adjustment is usually on that top 8). I already do have a list box so the user can select a value that is not shown in the top 8. There are so many values of code text in that list box, that I really do not want to hard code, because new values are added all the time.
I would consider adding a second expression but with a set modifier in it like
<[Code Text] -='Inventory Adjustment'>
You don't want to show both at the same time, you'd prefer to toggle between them so you could create a variable say, vShowInvAdj, that toggles between 0 and 1 and set the display conditions for the two expressions based on the value of this variable.
Set the condition for one to $(vShowInvAdj) and set the other to 1- $(vShowInvAdj).
Make a button with a Set Variable action vShowInvAdj =1-$(vShowInvAdj).