Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi! I have a straight table where I would like to put a dimension limit based on dates. In the table below I would like that all values from 2010-Dec up to (and including) 2011-Sep should be "Others". I do not want to use "largest values" since this might not be correct if the values change. Thanks
Edit your dimension "Booking Month" and write:
if your field is [Booking Month] then
If([Booking Month] >= '2010-Dec' and [Booking Month] <= '2011-Sep', 'Others, [Booking Month])
Edit your dimension "Booking Month" and write:
if your field is [Booking Month] then
If([Booking Month] >= '2010-Dec' and [Booking Month] <= '2011-Sep', 'Others, [Booking Month])
Thanks Alessandro! That worked great!
If you don't want the result by Calculated Dimension, it's difficult as there is no Last selection in dimension limit.
Another work around is
Sort the Booking Months by descending order
Select First in dimension limit
In values write below formula
=COUNT(DISTINCT [Booking Month])-11
Change 11 accordingly...
Hope this helps...