Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
my QVW
you want to combine three charts into one? and other than the three SOURCE chart should not show the value?
Hi Arul
Yes you are right. only 3 out of 5 value label have value.
Paul
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
Hi Arul
Thank you very much.
Paul
Welcome