Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have below dimension and expressions in pivot table. This will give data values between 23/06/2014 and 29/06/2014
Dimension1: Member
Dimwnsion2: Type
Expression1 =Count({<EnteredDate={">=$(=Date(WeekStart(Today(1)-7))) <=$(=Date(WeekEnd(Today(1))-7))"}, Solutions={'Open','open'}>}CustomerID)
Ecpression2 =Count({<EnteredDate={">=$(=Date(WeekStart(Today(1)-7))) <=$(=Date(WeekEnd(Today(1))-7))"}, Solutions={'Further Data'}>}CustomerID)
what my doubt is will I get the values change every week automatically based on expressions? suppose if I run the report on 07/07/2014 the table should show values between 30/06/2014 and 06/07/2014
can anyone clarify my doubt please.
Thanks.
Try this:
=Count({<EnteredDate={">=$(=Date(WeekStart(Today(1)-7))) <=$(=Date(WeekEnd(Today(1))-9))"}, Solutions={'Open','open'}>}CustomerID)
Yes, the today() function will return a different date on July 7 then on July 4. Therefore the expressions will return different values.
Thanks for the confirmation.
can I know please how can I change the above expression if I want the data from Monday to Friday. I,e now the above expressions will show data from Monday to Sunday. But I need Monday to Friday. I tried to change the expressions but it seems not working for me. why I am asking here we calculate the weekend data as separate. so I don't want to include weekend data in these report. Please can suggest me.
Try this:
=Count({<EnteredDate={">=$(=Date(WeekStart(Today(1)-7))) <=$(=Date(WeekEnd(Today(1))-9))"}, Solutions={'Open','open'}>}CustomerID)
Thanks.