Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi
Use like this, If(Month(DateField) <= Month(Today()), Month(DateField)) as Dimension
Hope that helps
Hi
Use like this, If(Month(DateField) <= Month(Today()), Month(DateField)) as Dimension
Hope that helps
Thanks Mayil, Just wondering if there was an simpler way that didnt need a calculated dim.