topic Re: Need advice in Reporting Service & Alerting

Need advice

Julies — Fri, 04 Mar 2022 08:55:24 GMT

I have 3 group data. I need to get Feb 2020 total from group 3 and the filtered date was 1/3/2020, it returns the filtered date month total if used the expression below, where went wrong?

Group:3

Date	Total
1/2/20	5
2/2/20	4
3/2/20	5
. . .	. . .
1/3/20	3
2/3/20	3
3/3/20	6

Sum({<[Date]={">=$(=(MonthStart(AddMonths(Max(Date),-1)))) <=$(=(MonthEnd(AddMonths(Max(Date),-1))))"}>}{$<Group={'3'}>}[Total])

Re: Need advice

anat — Fri, 04 Mar 2022 11:02:47 GMT

Sum({<[Date]=,[Date]={">=$(=(MonthStart(AddMonths(Max(Date),-1)))) <=$(=(MonthEnd(AddMonths(Max(Date),-1))))"}>}{$<[Date]=,Group={'3'}>}[Total])

can you try bypassing the date field

Re: Need advice

Julies — Sat, 05 Mar 2022 09:02:21 GMT

Thanks so much, Anat