Percent count in a pivot

[#1]

I have a pivot table with two columns. In the first column i make a count of the abonnees. How can i get the percent of that counts in the second column from the total abonnees of that row.

Who can help me with this problem?

[#2]

HI,

You try this:

=Num( Count(Aantal)/Count(Total Aantal) * 100, 0.00) & '%'

Regards

[#3]

=Num(Count(Klantnummer_BC)/Count({<VertegenwoordigerId={'2'}>}Total Klantnummer_BC))

This one works only for the first column. How can i make {<VertegenwoordigerId={'2'}>} variable so he takes the columnvalue?

[#4]

Hi Dirk

I didn't get your idea on this one.

dirkgroen wrote:
 How can i make {<VertegenwoordigerId={'2'}>} variable so he takes the columnvalue?
<div></div>

You want to save the value of Vertegenwoordigerid in a variable?

[#5]

i need the total of abbonements of that VertegenwoordigerID

[#6]

HI,

Ahh.. ok.. how about adding '$' in to your expression:

=Num(Count(Klantnummer_BC)/Count({$<VertegenwoordigerId={'2'}>}Total Klantnummer_BC))

[#7]

When i hardcoded set de vertegenwoordigerID on 2 it works for the first. But not for the others. so VertegenwoordigerId needs to be variable and abonnementen not.

[#8 · Accepted solution]

This is the sollution.

=Num(Count(Klantnummer_BC)/Count(Total <VertegenwoordigerId> Klantnummer_BC))

Thanks anyway

[#9]

Hmm.. can you share to us your file? (or a sample of it) so that we can help you more