Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Friends,
I appreciate your time. I am having a sharedcalendar which is sharing 6 dates say DATE-PR,DATE-RFQ,DATE-PO,DATE-GRV,DATE-INVOICE, DATE PAYMENT. I am as of now using a cross table logic for my shared calendar as below:
//
tabLink:
CrossTable (Datetype, Date,6)
LOAD
//key,
[Date - PR] ,
[Date - RFQ] ,
[Date - PO],
[Date - GRV],
[Date - Invoice],
[Date - Payment],
[Date - PR],
[Date - RFQ],
[Date - PO],
[Date - GRV]
Resident Fact;
left join(Fact)
TABLINK2:
LOAD
Date as Shared_Date,
Datetype,
[Date - PR],
[Date - RFQ],
[Date - PO],
[Date - GRV],
[Date - Invoice],
[Date - Payment]
resident tabLink;
drop table tabLink;
This is working fine, but now I need to include another condition in this as when I click shared date,
, then it need to show only the same date value from other date fields. Let say when I click, 1/1/2014 from shared-date then if it is present in other date fields say in DATE-PR or DATE-RFQ then it need to show the same otherwise it need to get grayed out.
As of now it is showing a lot of other dates along with the selected date in shared calendar, but my scenario is to show only that particular date which I am clicking on the shared-date.
Attached a screenshot for your reference.
Kindly let me know.
Kind regards,
Kiru
Guys, please let me know in case if you has any solution.
Kiru