Limit dimension values shown

[#1]

Hi community,

I would like to limit the dimension values shown, i.e. I don't want months greater than today's.  Is there away to limit the last x dates shown.  The values for up coming months aren't necessarily zero and we are actually still useing QV 10 on the server.  Any thoughts?

[MayilVahanan · Accepted solution]

Hi

Use like this, If(Month(DateField) <= Month(Today()), Month(DateField)) as Dimension

Hope that helps

[#3]

Thanks Mayil,  Just wondering if there was an simpler way that didnt need a calculated dim.