How to write expression?

[#1]

can  anyone help me with the expression please

attached is the table which should be build in report.

week is in horizontal as week1, week2,week3,week4

for eg: 207 is the difference of count of id if we take today. i,e today(wednesday)  minus last week(last wednesday) where Type= 'close','close/forward'
             78 is the difference of count of id if we take today. i,e today(wednesday)  minus last week(last wednesday) where Type=    'fail','fail/forward'

Thanks.

[#2]

please see attached.

[#3]

would this be possible to create?

[simondachstr]

Are you asking because you can't do it yourself or because you can't bother doing it yourself?

A pivottable would work just fine and you just need to drag the Week-dimension horizontally.

[#5]

I tried all but not working. only I have to show is the differences. So, I would need the expression. Is that possible? Please help.

I can get direct with dimension Week and expression as count(ID) . but here this is not the requirement.

[simondachstr]

Oh I see,

You will need to write two expressions. One for close, one for fail.

Use set analysis e.g.

Expression 1

Count({Type={'close,'close/forward'} ID)-Count({Type={'close,'close/forward', Week={'$(=Week-1)'} ID)

Expression 2

Count({Type={'fail','fail/forward'} ID)-Count({Type={'fail','fail/forward', Week={'$(=Week-1)'} ID)

Not sure if Week={'$(=Week-1)'} part would work - if possible can you upload a data set of what you are currently using?

[#7]

Thanks. will try and let you know.