Previous months average meeting the condition

[muhammadraza]

Hello Guys,

I want to take average of previous six months but after meeting the condition,

I have tried to achieve it but I am not getting the desired results, PFA is my excel and QVW file. Sheet1 contains the data and sheet2 describes what is needed to be achieved.

It is needed to be achieved on presentation only.

Best Regards,

Muhammad Raza

[Gysbert_Wassenaar]

See attached qvw.

[muhammadraza]

Thanks for the reply but I cannot make any change into the datamodel, I have to achieve it through presentation.

[Gysbert_Wassenaar]

Then I very strongly recommend you use MS-Excel. Qlikview is not a spreadsheet program.