+ Reply to Thread
Results 1 to 2 of 2

Shift rows below PivotTable down when PivotTable expands (PowerPivot)

  1. #1
    Registered User
    Join Date
    01-13-2011
    Location
    Boston, Massachusetts
    MS-Off Ver
    Excel 2010
    Posts
    87

    Shift rows below PivotTable down when PivotTable expands (PowerPivot)

    Hello all: I am trying to create a financial statement from PowerPivot table (which gets its data from an ODBC database) and I'd like to add some manual calculations below the PT. For example, I may want to add back or subtract out certain line items from the Grand Total line and show the results below the PT. However, the PT has a lot of groupings which may be expanded or collapsed at different times, and if a grouping expands it overwrites the data right below the PT. Is it possible through VBA to automatically move these calculations below the expanded PT so that they are not overwritten? If using ordinary PivotTables I could try a Calculated Item so I wouldn't have this issue, but ordinary PTs can't handle the amount of source data (or the fact that the source data had calculations, a fact which isn't in my control at all).

    Thank you in advance for any support.

  2. #2
    Registered User
    Join Date
    01-13-2011
    Location
    Boston, Massachusetts
    MS-Off Ver
    Excel 2010
    Posts
    87

    Re: Shift rows below PivotTable down when PivotTable expands (PowerPivot)

    Is there an easier solution that I may be missing? There may be a chance that excel 64, which I may upgrade to, can handle the calculated items calculation but I'm not sure.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1