Please support in below requirement. I need to achieve this requirement in front end only.
Requirement :- I need to create pivot table with creation date (CRE_DT) as dimension and one expression
1) No ETD -- count(LATEST_ETD where LATEST_ETD = 99999999) But here i need to consider ORD_DT and ORD_TIME. i.e.
For each creation dates(CRE_DT) there will be set of ORD_DT and ORD_TIME, In each case i need to consider upto Max(ORD_DT and ORD_TIME <= 163000).
Business Logic :- My WH team will receive orders whole day but for this report i need to consider orders received upto 4.30 PM. EG:-
IF Creation Date :- 1ST JAN 2014 then for this date i will have many ORDER DATES eg:- (1st SEP 2013 to 29th DEC 2013 till mid night) but for my report i need to consider 1st SEP 2013 full Day to 29th DEC 2013 4.30 PM.
Please find sample data and application. Please support.
Note :- I need to do in front end only. (set analysis).
