How to calculate current weeks and current 12 weeks Sales in Pivot Table?

[Anonymous]

Hello Everyone,

Need Urgency

I have Actual Budget for every weekend in every month over the years.

In pivot table Dimensions are Brands and Business Unit.

Can you please help me to find out the Current 4 weeks Budget and YAGO Current 4 Weeks Budget ?

Please help me as early as possible

Thanks,

Amar

[kaushiknsolanki]

HI,

Check this link. Hope this will help.

The Magic of Set Analysis - Point in Time Reporting

Regards,

Kaushik Solanki

[Gysbert_Wassenaar]

Maybe something like this:

sum({<BudgetWeek={'>$(=max(BudgetWeek)-4)<=$(=max(BudgetWeek))'}>}[Actual Budget)

sum({<BudgetYear={$(=max(BudgetYear)-1)}, BudgetWeek={'>$(=max(BudgetWeek)-4)<=$(=max(BudgetWeek))'}>}[Actual Budget)

If not, please post a small Qlikview document that illustrates the problem.