Current Week vs last three week trail

[abhaysingh]

HI All,

What would be the logic for Current week Vs Last three Week Trend..

thanks In advance..

[abhaysingh]

Kindly revert

[abhaysingh]

Kindly revert

[abhaysingh]

hi All ,

i tried in this way...

max(week)

Max(week)-3

is not working kindly help

[abhaysingh]

=Sum({ < week=,  Week  ={">=$(='$(vLast3Week)')<=$(='$(vMaxWeek)')"}>}    [Outstanding Amount])

[ecolomer]

Here you have an example with 3 month, for the week are similar

Saludos,

EC

[abhaysingh]

Hey Enrique, Month Wise Done.. But Facing issue with week wise

[ecolomer]

Give me your QV file and expalin the requeriment please

[abhaysingh]

Hi Enrique, here u can find scramble app.. what i want is Current Week Sales Vs Last 3 Week Sales.

let say my current week is 18 and last three week are w17, w16,w15 so in bar chart i want that trend.

Thanks

[ecolomer]

In this example you don't have data for week

week are no valours