Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I'm sorry, Can you explain more, please.
He means this: Previous months average meeting the condition
Hi Guys,
I have done it this way.