6 Replies Latest reply: Jul 26, 2016 8:22 AM by arul settu

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

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

my QVW

• ###### Re: How to make SOURCE={'TDSS'} Dynamic ?

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

• ###### Re: How to make SOURCE={'TDSS'} Dynamic ?

Hi Arul

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

Paul

• ###### Re: How to make SOURCE={'TDSS'} Dynamic ?

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

• ###### Re: How to make SOURCE={'TDSS'} Dynamic ?

Hi Arul

Thank you very much.

Paul

• ###### Re: How to make SOURCE={'TDSS'} Dynamic ?

Welcome