I’ve a PowerPivot model with different granularities.
I’ve actuals per week and budgets per months. If I add weeknumber to the pivot table, the weeknumber is also for budgets and I don’t want that. For instance April has 4 weeks, therefore 4 columns for actuals and 4 columns for budget. I want 4 columns for actuals and 1 for the month for the budget.
Question: How can I combine them together in the Pivot table?