Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please find attach sample data with in sheet 2 required output
Try:
Max Purchase Date Price: FirstSortedValue({<Year={'$(=Max(Year))'}>} [Unit Price], -Date)
Min Price: Min({<Year={'$(=Max(Year))'}>} [Unit Price])
Its Current Most Max Purchase - Price & Minimum Price purchased in same org for same item in selected Year
And your question is?
Minimum Purchase Price againt that Item & Org .. check SHeet 2 in excel.. with Expected Output
Straight table:
Dim1: Org
Dim2: Item
Exp1: Max({<Year={'$(=Max(Year))'}>} [Unit Price])
Exp2: Min({<Year={'$(=Max(Year))'}>} [Unit Price])
The logic should be Current means Max Purchase Date - againt that Price ..& Min Price Means in selected Year for Same Item & Org Minimum Purchase Price.
if A item Purchase in Jan at rs. 350, in Feb at Rs. 300 & in Mar at rs. 200 than output will be below
A - Current Purchase Price will be 200, & Minimum Price will be 200.
F23 Org is missing in your expected output? Not sure why!
Your date format is DD-MM-YYYY or MM-DD-YYYY?
F23 is missing bcz output year is 2016 & date format is DD-MM-YYYY