Please attach a workbook or Alternatively Set up some Criteria like This;
If SUM(Room Nights)<=1 THEN "1"
SUM(Room Nights)<=2 THEN "2"
thanks but the sum amount is dynamically changing over time. If the number were fixed it would be much easier
That Should not affect, because if your Measure is changing the above calculation would take care of it. Can you attach some dummy workbook with dummy data.