Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
i have below SET expression working fine :-
=Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}distinct REVENUE_C)
When user select OMRON_1 , TEXT 1 Display zero.
The reasons why user click on OMRON_! it display zero because the date is 1 Dec 2016 or 1 Dec 2015 and so on.In order to make it display , i need to select year = 2015. ( To make it work , i have change the date from 2016 to 2015 , which is not correct. )
How to make it display 12621000 when user select OMRON_1 ? by change the SET expression ?
Remark :- When user click on OMRON , it display 12821000.( Because i have replace 2016 to 2015 , which is not correct ).
I am at china now , unable to upload the QVW file
Paul
Create MonthYear field in script and
Aggr(Sum({$< sales = {'*'}>} distinct REVENUE_C),max(MonthYear))
Hi Paul,
Try
=Sum({$<year = {$(=Min(year))}, month = {"<=$(=Max({<year={$(=Min(year))}, sales = {'*'}>} month))"}>}distinct REVENUE_C)
Hi All
I have try 2 of the expression both of you propose, but it does not work.
Enclosed my QVW.
Hope some one can take a look.
Paul