Hi Shadmani, For hierarchy purpose create a rank line item with this formula: RANK(Date, DESCENDING, MINIMUM, TRUE, Emp ID) By using the Emp ID in the rank group argument, the ranks will be split for each employee. So the first three entries will have the rank of 3, 2, 1 respectively. The next employee will have its own ranking as well Now to create the hierarchy, create line items that exclude the metadata without the rank 1. For example the dates line item would be: IF Rank Hierarchy = 1 THEN Dates ELSE BLANK. Create similar line items for Country, Dept and Salary. Then use those line items to create the employee list after excluding the blanks For the calculation create another rank line item called Rank Calculation with the formula: RANK(Date, ASCENDING, MINIMUM, Dates <= START(Time.'Nov 20'), Emp ID) Now this formula will automatically exclude the entries after Nov 20 (They will have a rank of NaN) and just as before all the entries before 11/01/2020 will have their individual rank. I have used November 2019 in my screenshot: Again create line items which exclude all entries except rank = 1. Dates formula would be: IF Rank Calculation = 1 THEN Dates ELSE BLANK. Create similar line items for Country, Dept and Salary. Then use those line items to do your calculation 1 For calculation 2 use the same line items that you used to create the hierarchy Let me know if you need more help with this Regards, Anirudh
... View more