Return Sales Volume of Max Date For Each Product

[Former Member]

I can't seem to find a solution for this particular problem.

I have three dimensions: SKU; Date; Sales.

My goal is to only see the sales figures for the latest date for each product as can be seen below. I sadly always get a MULTIVALUE error. All suggesions are more than welcome. Thanks so much, Julian

[Tom_N8 · Accepted solution]

Hi Julian,

Create two variables:

1. [Max Date] =Max([Date]) In([SKU])
2. [Max Sales] =[Sales] Where([Max Date]=[Date])

Kind regards,

Tom

[Former Member · Accepted solution]

Thanks Tom, you saved me a ton of time. Works like a charm.