% of Total by Month and Year

[#1]

I am trying to build a pivot chart in QV that gives me the % of the total column. Right now I have two deminsions present Yr and Month.

Here is an example of what I am trying to do. I need to fill in the % of Deals column. (in July I would expect to see 50% for New and 50% for Upgrade)

	2010	2010	2010	2010	2010	2010	2010	2010	2010	2010	2010	2010
	Jul	Jul	Aug	Aug	Sep	Sep	Oct	Oct	Dec	Dec	Total	Total
New / Upgrade	# of Deals	% of Deals	# of Deals	% of Deals	# of Deals	% of Deals	# of Deals	% of Deals	# of Deals	% of Deals	# of Deals	% of Deals
New	1	-	2	-	3	-	10	-	4	-	20	-
Upgrade	1	-	4	-	9	-	1	-	6	-	21	-
Total	2	-	6	-	12	-	11	-	10	-	41	-

Any help that could be provided would be great.

Thanks

Tim

[stephencredmond]

Hi,

Something like this should do the trick:

Sum(Value)/Sum(TOTAL<Month> Value)

Regards,

Stephen

Stephen Redmond is author of QlikView for Developer's Cookbook

He is CTO of CapricornVentis a QlikView Elite Partner. We are always looking for the right people to join our team.

Follow me on Twitter: @stephencredmond