Count Number of Months With Sales above average per customer

[sogloqlik]

Hi.

I have the following requirement:

For every customer, I Have to count the number of months with sales above average.

The average is calculated for the sales of max year selected (Meaning if no year is selected it is 2021,) divided by the number of months selected (Jan-May = 5).

the count itself must conclude all the years.

See file with example.

The only thing which is different from the example is that sales is a very complicated expression hence it is implemented in a variable - $(Sales). I Can't touch it.

Regards,

Motty.

[eddie_wagt]

You are welcome. Wish you the best. 

[sogloqlik · Accepted solution]

This is the Expression that eventually gave the desired results:

Sum(Aggr(If(Sum(Total <[Customer]>aggr({<Year={$(=Max(Year))}>} $(vSales)
, Customer))
/ GetSelectedCount(Month) < $(vSales), 1, 0), [Customer], Year, Month))

Thanks for all of you who tried to help