Home Forums Power Pivot Pivottable with different granularity

This topic contains 1 reply, has 2 voices, and was last updated by  tomallan 3 years, 4 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
  • #4261

    • Started: 25
    • Replies: 52
    • Total: 77


    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?




    • Started: 7
    • Replies: 2580
    • Total: 2587

    Are your budgets and actuals in the same table or in different tables?

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.