Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My concerns is i have to pass all the years through varibles dynamically, in below i have hard coded years but tomrrow it will add the two More years like 2018 Or 2019 so that i have to pass the years dynamically through variables.
(RPT_YR = 2012 OR RPT_YR = 2013 OR RPT_YR = 2014 OR RPT_YR = 2015 OR RPT_YR = 2016 OR RPT_YR = 2017) AND
(COMP_DESC = 'COKY' OR COMP_DESC = 'MDP' OR COMP_DESC = 'MOCHA' )
(RPT_YR = $(Year) AND COMP_DESC = $(CompanyName))
Please let me if i am missing in the above expression or adding
Do you want to ignore selections?
If so you can do like this:
Sum({<[RPT_YR]=, COMP_DESC= >Value)