Multiple SUMIF based on current row date (eg: <= 12 months = N, <=24 months and >12 = N1)

[Soorajsu]

I need help from the community.

I am trying to perform a SUM on qty where the data is <= 12 months = N, <=24 months, and >12 = N1 based on the field "First day of Month". For example,

Sample dataset attached.

[Qiu · Accepted solution]

@Soorajsu 
I hope this you need.

N, N-1 made things a bit complicated. 😁

[Soorajsu]

@Qiu 

Thanks for the help, but the data needs to be grouped into all dimensions.

[Qiu]

@Soorajsu 
Can you give me more details on more dimensions?

[Soorajsu]

@Qiu  - Thanks for your help. It works.

[Qiu]

@Soorajsu 

Glad to help and thank you for the accep mark😁