QlikView Pivot table to calculate percentage by row

[vijaymadhavan28]

Hi Experts,

I am experiencing a scenario where pivot table shows correct set of percentage values as shown in Screenshot (1) when I try to explore the placement ratio % of  (Days / Total) for an individual company. However, when I try to bring more companies into this table (Example: Top 3 companies), placement ratio percentage is getting calculated as "Day / Overall Total of submissions" as shown in Screenshot (2). 

I need placement ratio % to be calculated by row for each companies. Is this possible to implement here?

Screenshot (1):

Screenshot (2):

Looking forward for your comments.

[MayilVahanan · Accepted solution]

Hi

Hope this helps

For individual company, you need to use Total<Company> in ur expression instead of Total alone. 

Ex: Count(days) / Count(Total<Company> days)