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

# Two Grand totals but one measure in the table columns?

Hi,

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

• ###### 1. Re: Two Grand totals but one measure in the table columns?

Attachment missing.

• ###### 2. Re: Two Grand totals but one measure in the table columns?

Hi Leandro,

something like this?

Just include year in your LOD to calculate the months correctly.

Hope this helps,

Soham

• ###### 3. Re: Two Grand totals but one measure in the table columns?

Hi Soham, thanks for the answer.. but I guess the calc was right. In fact I'm more interested in the way "CM - months with purchases" is shown than the sum of sales. I'd like it to show just next to the total sum of sales and be able if it's possible to order by this field.