How to write set analysis of current year sales for product which sold last year

[debabrata_sahoo]

Hi everyone,

Please help me to write set analysis of current year sales for product which sold last year .

Source:-

Product       Year         Sales
A                   2017            100
B                   2017           200
C                   2017            300
A                   2018            400
B                   2018            500
D                   2018            600

Output:- 

Product            sum of Sales
A                                  400
B                                  500

Thanks

[agigliotti · Accepted solution]

maybe this:
=sum( {< Year = {"$(=Max(Year))"}, Product = {"=Sum( {1< Year = {[$(=Max(Year)-1)]} >} Sales )>0"} >} Sales )
I hope it helps.

[albert_guito · Accepted solution]

Hi,

Try with this expression:

SUM({<Year={2018},Product=P({1<Year={$(=Max(Year)-1)}>})>} Sales)

You can custom the current year with a calculated vale also

Ag+

[debabrata_sahoo]

Its working. Thanks...