Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I am trying to create a list box based on input from 3 fields. The three fields contain numerical spend data. I would like to use the list box to the populate a chart based on the criteria selected.
The 3 fields would be structured as such:
Supplier | PVO 3rd | PVO Sec | PVO Div |
---|---|---|---|
1 | $4 | ||
2 | $5 | ||
3 | $1 | ||
4 | $5 | ||
5 | $6 | ||
6 | $3 | ||
7 | $7 | ||
8 | $1 |
The criteria in the list box should then be "PVO 3rd", "PVO Sec", and "PVO Div". Based on the criteria selected, the chart would show the total amount of spend. In the above example, if "PVO 3rd" were selected, the chart would show a total of $16. Currently, when I try to select PVO 3rd as a criteria, all of the fields numerical values appear as criteria.
Any suggestions on how to proceed?
Thanks,
Gary
one solution could be with conditional expression
PFA
That works great, Massimo! Thanks for the help.