Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi.
i am intrested in matching the exact year week weekday (-52 weeks).
see example below here i wish for the data to be pushed to 201553 in the LY column.
LY Set analysis
=sum({<[År Vecka Veckodag] ={ ">= $(=Min([År Vecka Veckodag_LY]))<= $(=Max([År Vecka Veckodag_LY]))"},
//$(#vKnapp_jfr),
[ÅrSäsong] = ,
[År Vecka] = ,
År = ,
Månad = ,
[År Månad] = ,
Vecka = ,
Veckodag = ,
//[År Vecka Veckodag] =,
Datum =>}
Nettobelopp)
I have the following set analyis that steers that the LY column but wish for 201501-Må value to be represented in the LY column to match see below for how i wish the data to be presented.
År Vecka Veckodag | Fsg CY tkr | LY | |
---|---|---|---|
201553 - MÅ | 5019 | 4523 242 | |
You need to use Above() function to do that. There has been alot of discussion on this kind of requirement. You can look at those or provide a sample data so that we can show you how it can be done