I have a BAQ with part number, calculated the Year for the part was purchased, customer number, and cost. What I am wanting is something like:
Customer Year Part Number Cost for that year
XYZ 2017 AB12 10,000
And, only wanting the top 5 parts bought for that year for that customer.