Showing percentage in pie for a specific dimenion

[trishita]

I want to show the value of the Pesnionscheme=HPK for both HPPD and HPPI-K in the pie chart.

For example I want to show the  HPV Buchwert share  of HPK  (1192 out 6076) for HPPIK ( 2994 out 6076) 

which means want to show the share of Column 2 for HPK  /Total  value of Column 2 where Column 2 is HPV Buchwert 

[JordyWegman]

Hi Tri**bleep**a,

Try this function:

Count(Pensioneinrichtung) / Count(TOTAL Pensioneinrichtung)

And put this with the dimension Pensioneinrichtung in a measure.

Jordy

Climber

[trishita]

well i want to show the percentage for the second column HPV Buchwert not Pensioneinrichtung.
And HPV Buchwert is the quantity shown in the second column.

[JordyWegman]

Use this formula:

Count([HPV Buchwert]) / Count(TOTAL [HPV Buchwert])

Is Pensioneinrichtung still the dimension? Or something else? 

Jordy

Climber

[trishita]

not working