partial sum of the column on a pivot table

[#1]

Hello,

I need help, I have this pivot table:

Fig.1:

The column A : count(distinct id) and It's correct.

The column B is wrong :

Fig.2:

The column B must be (red bold):

greetings thank you very much

Valentina

[#2]

1,2,3 in column 'Risposta' are string and the column A is: count(id) and not the sum of  'Risposta'.

the column B must be the partial sum of count(id).

[bbi_mba_76]

Could you give same sample data?

[#4]

     

A:count(Id)

B:Count(Total<Mese> Distinct Id)

B is not correct.

the result must be :

[bbi_mba_76]

=aggr(nodistinct count(distinct Id), Domanda, Mese)

[#6]

B:Count(Total<Domanda, Mese> Distinct Id)

Perfect

thank you very much Valentina