+ Reply to Thread
Results 1 to 2 of 2

A new table based on PIVOT: filter & re-arrange the data

  1. #1
    Registered User
    Join Date
    05-27-2013
    Location
    brussels
    MS-Off Ver
    Excel 2003
    Posts
    5

    A new table based on PIVOT: filter & re-arrange the data

    Hi guys, I need your help on building an overview table based on the existing pivot. My example is attached. I have a PIVOT table with different type of costs, some of which are related to a brand (e.g. XXX, LLL). There's also a key Y/N if it is brand related in the next column. These costs are also organized per month - 3,4,5 (which stands for March - May). I need to create another overview on the next excel sheets which summarizes only brand related costs per month + accruals. Can you please help out?
    Attached Files Attached Files

  2. #2
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: A new table based on PIVOT: filter & re-arrange the data

    Hi,

    This can be done using "GETPIVOTDATA". Please post the actual file with Pivot Table after removing the confidential data, if any.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Pivot table filter based on arrays and copy average data to another sheet
    By millatshawn in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-14-2014, 05:33 PM
  2. Replies: 1
    Last Post: 02-07-2014, 03:12 AM
  3. Arrange Data on Pivot table in Ascending order
    By Excel Dumbo in forum Excel General
    Replies: 1
    Last Post: 07-19-2012, 08:53 PM
  4. Change Pivot table Filter Based on Cell Value *Multiple Filter items* Possible?
    By Flydd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-27-2012, 06:57 AM
  5. How do i arrange the data to create a pivot table?
    By mr1176 in forum Excel General
    Replies: 1
    Last Post: 01-29-2006, 01:35 AM

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