I need help in calculating WOW

[Naveed]

@Shaik

year_week

Hi

This may help you

Row context to calculate WoW, YoY, PoP

Hi @Andrea, Thanks for the further description. If that’s the case, I think you would need Level Aware Aggregations (LAA) here. The easiest way that I can think of right now: Extract just the week out from your “Week” column using split or right function - namely “Week Number” Get the latest year in your dataset, namely “Get the latest year in the dataset”: extract("YYYY",maxOver({Order Date - New},[],PRE_AGG)) Compute sales for current year, namely “Weekly Sales CY”: ifelse(extract("YY…

regards,
Naveed Ali