Change Excel Pivot table to Qlik Sense

[Anonymous]

Hello

I am looking at using a similar pivot table within Qlik sense as I have used in excel

I can crate the pivot table and make the columns and rows correct the only issue is the measure

The table uses the percentages of the total number from each column compared to the complete total 

i.e Total is 44 and number within Very Low column is 4 therefore percentage will be 10%

my original idea was to find the percentage by using the expression

=Count(name)/Count({1}name)

But this gives the percentage compared to the complete total not the total from the filtered selection

Is there a way to correct this

Pivot table

Column - Category

Row - SIMD Decile

thank you

[shraddha_g · Accepted solution]

Try

Count(name)/Count( ToTAL name)