How to get % in a column in Pivot Table

[pra_kale]

Hi,

I am attaching a application in which i want year wise % of a product Types.

like given below

Year	2014-15	2014-15	2015-16	2015-16	2016-17	2016-17
Type	Total_Sales	% Linked	Total_Sales	% Linked	Total_Sales	% Linked
Linked	3	37.50%	4	40.00%	7	58.33%
Non Linked	5	62.50%	6	60.00%	5	41.67%
Total	8		10		12

please help to get the desired out-put.

Thanks in advance.

[sunny_talwar · Accepted solution]

Try this:

Count(Policy)/Count(TOTAL <Year> Policy)

[pra_kale]

Hi,

Thanks Sunny it is working.

[sunny_talwar]

Awesome!! Close the thread by marking the correct response.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny