locked
PowerPivot-View with column which is displayed as last column RRS feed

  • Question

  • Hi

    I've an PowerPivot-Table in Excel with ProductGroups as rows, Month as Columns and Turnover as Values(SUM).
    A slicer of month let's filter to some monthes.
    An extra column calculates the total turnover of every ProductGroup of the full year.

    Is it possible to display the Turnover-Sums of the selected month and as the last column, the FullYear-Column should be displayed. When I move the turnover and FullYear-columns to the value-area, the FullYear-Column is displayed after every month. Should only displayed as last column.

    Any ideas?

    Best regards

    Christoph

    Wednesday, January 21, 2015 9:14 PM

Answers