Straight table issue

[#1]

I am using Qliksense

Attached please find the sample data, sample qvw and screen shot.  I have a Year and Launch Year fields.  So In each Year I can have multiple Launch Years, for example  Year=2016 will have launch Years 2016,2015,2014 etc

for Year 2015  will have launch Years 2016,2015,2014 etc.

Now I want to use the following grouping:

=If(LaunchYear >= Year,'<1 Year',

If(LaunchYear >= (Year-2) and LaunchYear < Year,'Prior 2 Years',

If(LaunchYear <= (Year-3), 'Prior 3 Year')))

But at the same time I want to exclude any future Launch Years. For  example , If I am in Year 2015, I  want to see only Launch Years <= 2015 and then in the last column I would to sum the total for each Year.

Looking for the solution

[#2]

This does give me the sum  at the Year level , but the sum is not right.  If you sum the Values in the Volume column for the Year they dont add up to the total value

[sunny_talwar]

Cannot test this, but how about this:

Aggr(NODISTINCT Sum(If(LaunchYear < Year, SPLTQTY)), Year)

[#4]

Nopes doesnt work