Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
ecems
Contributor II
Contributor II

% (percentage) of column in pivot

I want to calculate %  in pivot but i couldnt. 

I tried

Count / TOTAL (Count)

Count / TOTAL (<CountFieldName>Count) but they dont work.

For ex. in the higlighted cell, i want to see 9874 / 314780 --> %3,1

Could you please help me?

Thanks

I triedQlik2.PNG

 

 

Labels (3)
1 Solution

Accepted Solutions
BrunPierre
Master
Master

As follows

Count(Adet)/Count(TOTAL Adet)

View solution in original post

5 Replies
BrunPierre
Master
Master

Try with the actual field name.

=Count(IDs)/Count(TOTAL IDs)

ecems
Contributor II
Contributor II
Author

Hi;

should ı write IDs?  or instead of IDs what should I write?

 

thanks a lot

BrunPierre
Master
Master

Replace IDs with the actual field name.

ecems
Contributor II
Contributor II
Author

Field name is "Adet"; I tried Adet / TOTAL Adet but it doesnt work.

BrunPierre
Master
Master

As follows

Count(Adet)/Count(TOTAL Adet)