Help please!! I am using a variable as an expression to output a usage flag over the past 6 months to simply feedback into my straight table either 'Active Usage', '3Mths Nil Usage' or '6Mths Nil Usage'; all of which works hunky dory! However, the 1st thing I was asked when demoing the app was can I please filter on 1 of the flags? Having spent some time searching the forum & trying input boxes & even a slider by changing to '1', '3' & '6' I have reached something of an impasse & also a headache! For info the variable is as per; if(sum({$<YearMonthCounter = {$(=Num#(Max(YearMonthCounter)))}>}SessionGUID_Counter) +sum({$<YearMonthCounter = {$(=Num#(Max(YearMonthCounter)-1))}>}SessionGUID_Counter) +sum({$<YearMonthCounter = {$(=Num#(Max(YearMonthCounter)-2))}>}SessionGUID_Counter) +sum({$<YearMonthCounter = {$(=Num#(Max(YearMonthCounter)-3))}>}SessionGUID_Counter) +sum({$<YearMonthCounter = {$(=Num#(Max(YearMonthCounter)-4))}>}SessionGUID_Counter) +sum({$<YearMonthCounter = {$(=Num#(Max(YearMonthCounter)-5))}>}SessionGUID_Counter)=0,'6Mths Nil Usage', if(sum({$<YearMonthCounter = {$(=Num#(Max(YearMonthCounter)))}>}SessionGUID_Counter) +sum({$<YearMonthCounter = {$(=Num#(Max(YearMonthCounter)-1))}>}SessionGUID_Counter) +sum({$<YearMonthCounter = {$(=Num#(Max(YearMonthCounter)-2))}>}SessionGUID_Counter)=0,'3Mths Nil Usage','Active Usage'))
Can anyone help please? Also, any ideas if/how I could make it a calculated dimension?
ps - I put forward the option of the search button from the 'Presentation tab & was roundly shouted down as for 1 it's a fairly ugly option
