Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Table 1:
timind_ID Timing
1 9 - 9:30
2 9:30 - 10
3 10 - 10:30
Table2:
tiiming_ID BookingDate
2 21/5/2012
3 22/5/2012
1 23/5/2012
1 22/5/2012
3 21/5/2012
Result:
Timing 21/5/2012 22/5/2012 23/5/2012
9-930 Booked Booked
9-30 - 10 Booked
10- 10:30 Booked Booked
You could try it like this:
Just load your tables as is (I think in above post, there are some typos which probably are not part of your script?).
Then create a pivot table with dimensions BookingDate and Timing and as expression
=if(timing_ID, 'Booked')
Then drag BookingDate dimension to the top of the pivot.
Hope this helps,
Stefan
i need to show today ,tomorrow,dayaftertomorrow booked date only...
I tried like this but its not working
timing as dimension
expression like =if(Booking_Date = Today(), 'Booked',' ')
but its not working
With my suggested chart, either try a calculated dimension instead of dimension BookingDate (still first dimension Timing):
=if(BookingDate>=today() and BookingDate<=today()+2,BookingDate)
(and check Suppress when Value is Null in dimension tab)
or a set expression as expression
=only({<BookingDate={">=$(=today())<=$(=today()+2)"}>} if(timing_ID,'Booked'))