I am creating a report with following columns:
Market Code,Room Nights, Room Revenue, ADR, . ADR is calculated by Room Revenue/Room Nights.
COR 5 450 90
IND 3 360 120
Total 8 810 101,25
The above is correct.
If I know I used the Combine Results based on uniion as i want to add another layer showing the same figures by Channel, the total for room nights and Room Revenue will be still correct , but ADR will show the value of the first row in each layer. In market code layer in the ADR Total i would have 90.
Any idea?
Regards
Sorry, it doesn't save the format. Here you are
