10 Replies Latest reply on Feb 20, 2018 3:47 AM by Zhouyi Zhang

# Previous week's measure value.

Hi Everyone ,

How to get the sum(Eop) of the last week when a week is selected in the filter. Please find the attached worksheet.

Please go to the EOP sheet . Requirement is to get the sum(EOP) of previos week to the week selected in the filter. Please use Weekly_Subs Datasource.

Thanks & Regards,

Deepak

• ###### 3. Re: Previous week's measure value.

Hi Deepak,

Find my approach as reference below based on parameter.

Last week calc:

Calculation to filter set to True.

~Tushar

• ###### 4. Re: Previous week's measure value.

Hi, Deepak

Please find my solution attached as well as below screenshot

Hope this helps

ZZ

• ###### 5. Re: Previous week's measure value.

Hi Tushar ,

Can you please attach the workbook you have developed.

Thanks

Deepak

• ###### 6. Re: Previous week's measure value.

Here you go.

~Tushar

• ###### 7. Re: Previous week's measure value.

Hi Tushar ,

Is there any way to show both. I mean current week and previous week. Actually requirement is to show the growth from previous week .  Thanks.

Regards,

Deepak

• ###### 8. Re: Previous week's measure value.

Hi Deepak,

If you modify the Calculation1 field to include either last weeks or this weeks then you can drop on your date field and set it to discreet to do this. You can then also use a table calc to work out the growth of the previous week. I've attached an updated version of the workbook for you to have a look at.

If you just wanted the growth then you could easily remove the total element. What is it that the user is trying to understand? It might be that another way to show this adds a lot more value than just the cold figures that are being displayed at the moment.

Thanks

Rob

• ###### 9. Re: Previous week's measure value.

Create a copy of my calculation 1 and change 1 to 0. This will give current week.

Hope this helps.

~Tushar

• ###### 10. Re: Previous week's measure value.

If you look at my workbook on sheet EOP, your expected result shown as below

ZZ