3 Replies Latest reply on Oct 22, 2018 10:47 AM by Leandro Baldassin

    Two Grand totals but one measure in the table columns?

    Leandro Baldassin

      Hi,

      i've been trying to achieve -just a simplifying example- the following...

       

      1.png

      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..