Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
HI,
Check this link. Hope this will help.
The Magic of Set Analysis - Point in Time Reporting
Regards,
Kaushik Solanki
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.