2 Replies Latest reply: Mar 4, 2014 11:24 AM by BELEN VERA GARCIA

# Percentage subtotal

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%

• ###### Re: Percentage subtotal

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) )