Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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% |
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) )
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) )
Thanks!