I have a screen where there are 10 different charts that all measure sales over time. (Each chart has different set analysis to make a different view.) I would like to be able to substitute the sales in my expression, =sum( "set analysis" sales) that is in each of the 10 charts with transactions, =sum( "set analysis" transactions).
Is there a way to set up an input box that would make this more dynamic? I do not want to have to use a group-by expression for each chart and then cycle through the expressions that way.
Thanks in advance for any help.