How to make SOURCE={'TDSS'} Dynamic ?

[paulyeo11]

Hi All

Now i need 3 Table , my goal is make it only 1 table .

Expression for TDSS :-

Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"},SOURCE={'TDSS'}>}BK_TAR)

Expression for TDST

Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"},SOURCE={'TDST'}>}BK_TAR)

Expression for TDSID :-

Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"},SOURCE={'TDSID'}>}BK_TAR)

May i know how to make it dynamic :-

when i select SOURCE = TDSS , Table 1 will display Monthly target = 76,389.00

when i select SOURCE = TDST , Table 1 will display Monthly target = 34,722.00

when i select SOURCE = TDSID , Table 1 will display Monthly target = 27,777.78

Paul

[paulyeo11]

my QVW

[arulsettu]

you want to combine three charts into one? and other than the three SOURCE chart should not show the value?

[paulyeo11]

Hi Arul

Yes you are right. only 3 out of 5 value label have value.

Paul

[arulsettu · Accepted solution]

in single chart use this expression

Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"},SOURCE-={'ADL','TDSKL','TDSPG',''}>}BK_TAR)

other than this values from list box if u select the chart will change

[paulyeo11]

Hi Arul

Thank you very much.

Paul

[arulsettu]

Welcome