Percentage in pivot table

[juliakhaa]

Hello to the whole community!

I can’t figure out how to turn the integer values from the table in the first picture into percentages like in the second picture. 
I get wrong and large values with any formatting.

measure count(bank)

 

 

ps. The percentages will be different as in qlik data for the newer date.

[avinashelite]

=Num(calculation or the field ,'##%')

[avinashelite]

You could also check the filed value settings to show in percentage also 

[vinieme12 · Accepted solution]

As Below, use the TOTAL keyword to calculate percentage total for each Bank

= count(bank) / count(TOTAL <bank> bank)

After this choose Number Format as Percentage

[juliakhaa]

I get the wrong %

 

[juliakhaa]

 

I think it’s works, but I get no values for the "-" column 

[vinieme12]

thats simply because there is no data for that dimension so there is nothing to evaluate

[juliakhaa]

I see, thank you