master item expression

[Wallibee]

Hi

I am trying to show turn over figure  for some dimensions 

Type of organisation 

Organisation 

Sales channel 

Type of customer

I would like to compare this with time dimension for example 

last year 

last week 

Yesterday 

How can I calculate this given a Net price and  using master Items for easy self service .

Thanks 

[Chanty4u]

try this

  InWeekToDate(Date, WeekEnd(Today()), -1) as Lastweek,

 Date(AddYears(Date, 1)) as lastyear,

  Date(Today() - 1,'DD/MM/YY') as yesterday

[Wallibee]

thanks for the responds @Chanty4u 

I am trying to do this in the front end( Dashboard) using master items so I can show turn over figures compared to my Date dimension . if possible ideas on set analysis in my expression