Hi ,
I have a requirement to populate data based on User Input on Date selection and Some of the Key figures needs to be calculated Dynamically based on output data.
Example:
User Input on Date : 01.06.2023
Output

In above example, based on User input date (01.06.2023), PO Latest date needs to be picked. This I am able to achieve in BW query (taking Last Value).
Now for the column "Billed Qty", I need to calculate and populate based on "PO Latest Date" coming in the output for each Plant and Material wise. The Tricky part is "Billed Qty" is based on "Posting Date" whereas "PO Qty" is based on "Calender Day".
How Can I pass the date populated in the column "PO Latest Date" (Calendar Day) to "Billed Qty" (Posting Date) Column dynamically ?