Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
sum({$<year = {">=$(=max(year),4)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}, COMPETITOR = {'WAGO', 'iTDS'}>}distinct REVENUE_C)/1000000
Above expression from sunny , will plot the year from 2000 till YTD , may i know how to add filter to above expression , so that it will plot from year more then 2009 ?
Meaning i only want to see the chart 1 , X axis display from 2009 till 2015.
Paul
May be this:
Sum({$<year = {">=2009"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}, COMPETITOR = {'WAGO', 'iTDS'}>}distinct REVENUE_C)/1000000
My QV Doc
May be this:
Sum({$<year = {">=2009"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}, COMPETITOR = {'WAGO', 'iTDS'}>}distinct REVENUE_C)/1000000
Hi sunny
Many thank
Paul