Toggle display in chart

QFanatic — Mon, 21 Dec 2020 09:31:40 GMT

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

Re: Toggle display in chart

richard_chilvers — Mon, 21 Dec 2020 11:31:16 GMT

Try:

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