Percentage subtotal

[#1]

Hello,

I need to distribute 100% by each month and also by Brand, so the Brand should be the 100%.

First i tried with this formula wich is correct by month:  

sum (NUM_PAX_BKD_LB)/ sum (total <[Quarter Cruise]>(NUM_PAX_BKD_LB) )

And this is the result 

	Quarter Cruise	Q1	Q1	Q2	Q2	Q3	Q3	Q4	Q4
Brand	Fare Type	#	%Month	#	%Month	#	%Month	#	%Month
Total		10.372	100%	15.627	100%	26.778	100%	7.662	100%
xxx	Total	5.809	56%	7.081	45%	12.598	47%	2.512	33%
xxx	GRP	604	6%	294	2%	34	0%	-	-
xxx	HM	46	0%	419	3%	1.032	4%	486	6%
xxx	IND	5.159	50%	6.368	41%	11.532	43%	2.026	26%
YYY	Total	4.563	44%	8.546	55%	14.180	53%	5.150	67%
YYY	GRP	912	9%	1.165	7%	-	-	-	-
YYY	HM	16	0%	22	0%	231	1%	112	1%
YYY	IND	3.635	35%	7.359	47%	13.949	52%	5.038	66%

But what i need is also to fix the Brand and get a tablke like this one:

     Thanks!

	Quarter Cruise	Q1	Q1	Q2	Q2	Q3	Q3	Q4	Q4
Brand	Fare Type	#	%Month	#	%Month	#	%Month	#	%Month
xxx	Total	5.809	100%	7.081	100%	12.598	100%	2.512	100%
xxx	GRP	604	10%	294	4%	34	0%	-	-
xxx	HM	46	1%	419	6%	1.032	8%	486	19%
xxx	IND	5.159	89%	6.368	90%	11.532	92%	2.026	81%
YYY	Total	4.563	100%	8.546	100%	14.180	100%	5.150	100%
YYY	GRP	912	20%	1.165	14%	-	-	-	-
YYY	HM	16	0%	22	0%	231	2%	112	2%
YYY	IND	3.635	80%	7.359	86%	13.949	98%	5.038	98%

[MK_QSL · Accepted solution]

sum (NUM_PAX_BKD_LB)/ sum (total <[Quarter Cruise], Brand>(NUM_PAX_BKD_LB) )

or

sum (NUM_PAX_BKD_LB)/ sum (total <[Quarter Cruise], Brand, [Fare Type]>(NUM_PAX_BKD_LB) )

[#3]

Thanks!