Hello,
I have to display the Bookings Count, Overnight Stay Count and Total Amount.
I have the details for the selected period
Here my query :
select{ [Measures].[Bookings Count], [Measures].[Overnight Stay Count], [Measures].[Total Amount] } on 0, { [Arrival Date].[Date].[2013-10-01]:[Arrival Date].[Date].[2013-10-04] } on 1 from [Booking_Cube]And the result :
Bookings Count Overnight Stay Count Total Amount
2013-10-01 7300 21471
3374092.42
2013-10-02 7226 19368
3031888.06
2013-10-03 7785 21938
3366338.1025
2013-10-04 8950 24842
3961734.525
And I want to render values differently.
Days Overnight Stay Count Total Amount
1 140 189010
2 105 156800
3 90 120080
4 95 122589
... .... ....
Means there are for the selected period 140 nights when the booking is for one night, 105 nights when the booking is for 2 nights...
How can I achieve this ?
Thanks
Antoine