Rolling average not working when apply the filter

[Zura Musa]

Hi,

I need some help to fix below issue:-

I need to show moving average for previous six months and it's is working fine if i didn't apply any filter and when i apply the filter by only select few months (less than 6 months),

somehow its only average based on how many months/weeks that Ive selected.. Is there any formula to fix this issueI've attached th sample for reference.

Thank you.

[Neil Kanungo 2]

Please re-attach your DXP but include your data. Your current attachment has no data embedded in it.

Please also provide more details describing your issue. Unfortunately, I was not able to replicate the problem.

[James Watts]

If you create a calculated column, its calculation will not be affected by filtering.