+ Reply to Thread
Results 1 to 1 of 1

Allocation of values from one Row item to others in a pivot table

  1. #1
    Registered User
    Join Date
    01-07-2016
    Location
    UK
    MS-Off Ver
    2010
    Posts
    4

    Allocation of values from one Row item to others in a pivot table

    I have a data set with several regions and costs associated to them. One of the regions is "Global" and it appears on the row list in my pivot table. I need to allocate costs all from the "Global" region against the other regions according to known %'s. Is this possible?

    See sample file attached.

    Any help would be much appreciated!

    Michal

    grab.PNG
    Attached Files Attached Files

+ 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. [SOLVED] Creating a formula in a pivot table while using another calculated item in the pivot
    By mvhs1073933 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-10-2015, 12:44 PM
  2. [SOLVED] Pivot table $ of each row item
    By ammartino44 in forum Excel General
    Replies: 1
    Last Post: 02-02-2015, 07:10 PM
  3. VBA Pivot Table: Problem with pivot item visibility
    By rotown21 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-22-2013, 03:56 AM
  4. Pivot Table Item Control
    By Zhadus in forum Excel General
    Replies: 5
    Last Post: 04-25-2009, 03:04 AM
  5. Replies: 0
    Last Post: 03-22-2009, 07:17 PM
  6. Replies: 0
    Last Post: 03-10-2006, 12:23 PM

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