Toggle display in chart

[QFanatic]

hi all

PFA,

In the attached model, in the chart, I want to user to click on the button to choose whether they want to see volumes or values of a table.

however it doesnt work...the values dont display in the expression...I have brain fogg....please assist?

Thank you

[richard_chilvers · Accepted solution]

Try:

SUM({<TABLE={'Teradata'}>} IF(vType = 'Value', VALUE, VOLUME))