Current week and last week Percentage increase of sales

[Anonymous]

Hi ,

I need to know the current week and last week percencentage increase of sales can i know how to acheive this

feild contain max date is aug 10 2018

week contains falg 1,0

1 as considered as week and o as considered as 1.

Please help me over this

Please provide me logic percentage increase based on max date current week and previos week

Thanks,

Yasdhan

[DavidŠtorek]

Hi,

I suggest to create not only flag for current week but allso for last week (just to make it more simple).

Do you want to know percentage change from previous week?

Sum({1<FlagCurrentWeek={1}>}Sales)/Sum({1<FlagLastWeek={1}>}Sales)

Above expression counts percentage difference between last and current week