Will the pivot table change the values automatically base on expressions?

[#1]

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.

[Gysbert_Wassenaar]

Yes, the today() function will return a different date on July 7 then on July 4. Therefore the expressions will return different values.

[#3]

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.

[Gysbert_Wassenaar · Accepted solution]

Try this:

=Count({<EnteredDate={">=$(=Date(WeekStart(Today(1)-7))) <=$(=Date(WeekEnd(Today(1))-9))"}, Solutions={'Open','open'}>}CustomerID)

[#5]

Thanks.