none
Combine Quarter and week in powerpivot graph?

    Question

  • Hi All,

    In powerpivot, is it possible to have different aggregation levels in one graph? Want I want to show are sales firgures per quarter for the last 3 quarters and then per week in the current quarter. So the table would be like this:

    Date Q1 Q2 Q3 W39 W40 W41 W42
    Sales 1000 1200 1100 89 110 70 78

    Thank you for your help!

    Kim

    

    Monday, November 11, 2013 9:37 AM

Answers

  • Hi All,

    In powerpivot, is it possible to have different aggregation levels in one graph? Want I want to show are sales firgures per quarter for the last 3 quarters and then per week in the current quarter. So the table would be like this:

    Date Q1 Q2 Q3 W39 W40 W41 W42
    Sales 1000 1200 1100 89 110 70 78

    Thank you for your help!

    Kim

    

    Hello Kim,

    I don't think we can achieve this requirement within one PivotTable. We need to design two PivotTable reports, one PivotTable report aggregate data at "Quarter" level, and the other one aggregate data at "Weekly" level.

    Regards,


    Elvis Long
    TechNet Community Support

    Saturday, November 23, 2013 6:52 AM

All replies

  • Any suggestions for Kim?

    Thanks!


    Ed Price, Power BI & SQL Server Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

    Answer an interesting question? Create a wiki article about it!

    Monday, November 18, 2013 3:11 AM
  • Hi All,

    In powerpivot, is it possible to have different aggregation levels in one graph? Want I want to show are sales firgures per quarter for the last 3 quarters and then per week in the current quarter. So the table would be like this:

    Date Q1 Q2 Q3 W39 W40 W41 W42
    Sales 1000 1200 1100 89 110 70 78

    Thank you for your help!

    Kim

    

    Hello Kim,

    I don't think we can achieve this requirement within one PivotTable. We need to design two PivotTable reports, one PivotTable report aggregate data at "Quarter" level, and the other one aggregate data at "Weekly" level.

    Regards,


    Elvis Long
    TechNet Community Support

    Saturday, November 23, 2013 6:52 AM