Posted: Mon Nov 02, 2015 11:09 am Post subject: Second Date
My Report/query(Custom SQL) is picking top 3 sales based on the dates.
User has asked to show the data in dimensions are in Vertical and only Dates and Measures are HorizontalWhile trying to build the report. As per this 3 dates.
First date am getting First function and 3rd date getting by using Last function. Could you let me know how to get 2nd/middle date. I tried but no luck.
Like below per each Well and DP , data show same row(Horizontal) Metrics are coming based on rank.
Let me know how to get the second Date. I tried rank not working .
Well DP Date Sales Rev Date Sales Rev Date Sales Rev
E p1 1-Jan-15 12 3 56 2 23-Mar-14 34 21
E p2 1-Dec-15 23 6 23 323 24-Jun-14 56 23
D p3 1-Jun-15 45 26 23 23 1-May-14 2 34
D p4 4-Jan-15 23 84 67 53 26-Mar-14 5 2