Home Forums Power Pivot Pivottable with different granularity

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

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

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

    Hi,

    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?

     

    Hennie

    #4271

    tomallan
    Keymaster
    • Started: 7
    • Replies: 2556
    • Total: 2563

    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.