Hi everyone,
I am trying to build up a tracking systems to manage our client. So far I have calculated a cumulative column that reset each FY. Now I can see the cumulative number of jobs for each month. For every 150 jobs, the clients received a gift.
I would like to do few things: How do I group then into bin of 150 with the cumultive resetting for the next month when I have reached the 150 mark?
Is there a way in BI to mark the event where there reach their target?
I would like for the column to display TICKET when the 150s is reached in another column next to the month in consideration
The left over after 150 needs to be distributed to the following month until we reached again the 150 and it needs to reset again This needs to happen by clients I hope someone can really healp here.
Thanks team.
