Aggregate, take sum by month and compare with percentage of average

[muhammadraza]

Hello Guys,

I have average of previous six months, 25% of the obtained average, (Done)

then comes the tricky part. I want to compare that 25% of the obtained average by (previous) each month total.

If total of the month < 25% then exclude that month and its total sales otherwise include.

Then I want to take the count of the excluded months (optional).

And after excluding the months with < 25%, I will take the average of the remaining months. (mandatory)

I need to achieve it through presentation only (not through load).

Please guide if it is doable or not.

PFA are the files.

Best Regards,

Muhammad Raza

[ecolomer]

I'm sorry, Can you explain more, please.

[Gysbert_Wassenaar]

He means this: Previous months average meeting the condition

[muhammadraza]

Hi Guys,

I have done it this way.