How to achieve % of column total in group by a dimension in pivot table in qliksense

[shashijss1]

Hi All,

This is related to Pivot table.

How to achieve the Total count% and TotalSale % per Dim Prod Cat grouping ex :Cloth .I tried default (rows and column in presentation)Total but its doing adding of rows values .Note that we have a dim Product -1 to 3 so any measure added get added a column under these 3 - product but i need one Total Count% and one TotalSale%.

Really appreciate for the suggestion and solutions.

				Product1	Product1	Product2	Product2	Product3	Product3
Dim ProdCat	Dim geography	Dim class	Dim Weight(kg)	count	Sale	count	Sale	count	Sale	Total count%	TotalSale %
Cloth	USA	Class1	0.5	2	90	1	300	2	300	2+1+2/2+1+2+3+2+3	90+300+300/90+300+300+100+200+400
Cloth	India	Class2	0.5	3	100	2	200	3	400	3+2+3/2+1+2+3+2+3	100+200+400/90+300+300+100+200+400
furniture	Africa	Class3	20	4	200	4	500	6	250	4+4+6/4+4+6+5+5+4	200+500+250/200+500+250+300+700+150
furniture	Austria	Class4	1	5	300	5	700	4	150	5+5+4/4+4+6+5+5+4	300+700+150/200+500+250+300+700+150