Calculate year on year movement only if current year exists

[stubarnes]

I'm trying to build a rate report that shows monetary changes year on year but only where a dimension exists in the current year

My data looks like this

ACC	Year	GWP
AAA	2017	1000
AAA	2018	1100
BBB	2017	1000
CCC	2017	1000
CCC	2018	1100

So in Year 2017 GWP is 3000 and Year 2018, GWP is 2200 but I only want to show 2000 in Year 2017 as BBB does not exist in 2018

I am getting stuck at excluding BBB!

[YoussefBelloum]

Hi,

try this:

=Sum( {<ACC = {"=Count(DISTINCT {1} Year) = 2"}>} GWP)