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

[bbi_mba_76]

Hi,

maybe aggr(nodistinct count(distinct id), Risposta)

[salto]

Hi,

column B, try with:

=count({<Risposta=>} distinct id)

Hope this helps.

[tresesco]

For column B, in expression use  TOTAL Keyword with dimension

[#5]

fig.1 have total but it's not correct , it's a column total.

[#6]

I tried all of these solutions, but these aren't correct 😞

[bbi_mba_76]

I made a test using sum(not count) and the expression =aggr(nodistinct sum(Val), Domanda, Mese)

[israrkhan]

Finally, Could you share an Example or your doc...

[CELAMBARASAN]

You could try this

Count(Total<Domanda, Mese, Riposta> Distinct id)

Also you couldn't explained what expression is there in B

[Gysbert_Wassenaar · Accepted solution]

Try count(total <Domanda, Mese> distinct id)