SAP Webi count for previous week status

[former_member327592]

Hi,

Hope you are well.I need help to get the table data in Webi .I have multiple projects with different status for different weeks(Attached in data.png). Can you please help me how it is possible to get the data looking at previous week for certain statuses as in the screen print(table-required).

Appreciate your help. Thanks

data.png

table-required.png

[former_member327592]

Hi Ayman,

Thanks a lot. I just removed NoFilter from the below logic. It seems working ok now.

NoFilter("OK" Where ([Status] = "Data Approved" ForEach([Project]) And ([KW] = ([KW] Where ([Status] = "Data submitted") + 1) In([Project]))))

[ayman_salem]

Very happy that I was able to help and my response got you figured out the solution to your requirement