This content has been marked as final. Show 3 replies
i've been trying to achieve -just a simplifying example- the following...
i.e. show the total count for months with purchases but not the count for every month. The idea is to count how many of the year's months a customer has made a purchase to do some analysis later based on that. I've made the attached example with the sample data but I couldn't find a way to get the desired output. CM - months with purchases should be hidden for every month and shown only as a total.
Any help would be appreciated..