Cumulative Count DISTINCT over Months - Remove Duplicates from previous Month
Have a scenarios where I need to do the Cumulative Count on SalesPersons for each Month, the requirement is if the person's ID is already counted in any of the previous months it should not be Counted again e.g.:
The result should be: Month ID_Count
Need to show it in Line chart, can't use Qlik's built in "Accumulate" option as it just adds values from previous month.