Pivot & Multiple Tables in MSP RRS feed

  • Question

  • 1. Trying to create a pivot table via reports section, while unable to find an option.

    2. Can a report be split into multiple small tables / graphs.

    Please guide

    Wednesday, November 20, 2019 5:50 PM

All replies

  • Scatterworlds --

    To answer your questions:

    1. The only way to create an Excel PivotTable is to create an Excel visual report.
    2. Yes, you can create a Dashboard Report that contains multiple tables and charts.  The Cost Overview report is a good example of this.

    Hope this helps.

    Dale A. Howard [MVP]

    Wednesday, November 20, 2019 7:35 PM
  • While generating Visual report get error as "building local OLAP cubes"
    Thursday, November 21, 2019 12:32 PM
  • Scatterworlds --

    Since Microsoft introduced the Visual Reports feature, I have noted intermittent errors such as the one you reference.  In fact, I had that same error one time while I was doing a webinar (very embarrassing, I might add).  The best I can tell you is that you just need to keep trying to create the Visual Report in Excel.  Sometimes it takes two or three tries to get the OLAP cube to build.  If you cannot get this to work at all, then I would recommend you open a ticket with Microsoft Support to let them help you resolve the problem.  Hope this helps.

    Dale A. Howard [MVP]

    Thursday, November 21, 2019 2:14 PM