[FONT="]Hello Geniuses,[/FONT]
[FONT="]I want to calculate % of room revenue from total revenue for 3 months in pivot table.[/FONT]
[FONT="]Months Aug’16 Sep’16 Oct’16 YTD Total
ROOM REVENUE 94 96 94 284
Total Revenue 134 132 128 394[/FONT]
[FONT="]% To Total Revenue 70% 72% 74% 216%[/FONT]
[FONT="]Grand total of % To Total Revenue should be (284 / 394 = 72%), but here is showing 216%[/FONT]
[FONT="]Can we fix this? Please help.[/FONT]
[FONT="]Thank you..
Nikunj[/FONT]
[FONT="]I want to calculate % of room revenue from total revenue for 3 months in pivot table.[/FONT]
[FONT="]Months Aug’16 Sep’16 Oct’16 YTD Total
ROOM REVENUE 94 96 94 284
Total Revenue 134 132 128 394[/FONT]
[FONT="]% To Total Revenue 70% 72% 74% 216%[/FONT]
[FONT="]Grand total of % To Total Revenue should be (284 / 394 = 72%), but here is showing 216%[/FONT]
[FONT="]Can we fix this? Please help.[/FONT]
[FONT="]Thank you..
Nikunj[/FONT]