Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
My set expression as below :-
Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}distinct REVENUE_C)
When i not select any year , it should be able display the latest sales amount.
But it does not work like above , i need to select year=2014 , then it able to display the amount .
May i know where go wrong ?
Paul
my qvf
The file is not opened, instead of that what is the target?
Hi Anil
If user not select any year , it should display the sales amount . Now user need to click year = 2014 , then it can display the sales value.
Paul
What are the diff b/w Sales Amount and Sales Value. And once user click the 2014 then we need to show only 2014 data for selection of Sales Value?
Hi
try like this !!?
Sum({ 1 <year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}distinct REVENUE_C)
Which Value is this?
Sales amount and revenue and sales value all are same.
You are right , when user select 2014 it will display 2014 sales amount .
Paul Yeo
Director
www.tdstech.com<http://www.tdstech.com>
HP+6285883521036 Indo
Why not fix for 2014 like this
Sum({<Year = {'2014'}>} [Sales Amount])