+ Reply to Thread
Results 1 to 9 of 9

Pivoting table to get output in 3 adjacent cells where each value is percentage of other

  1. #1
    Registered User
    Join Date
    12-03-2013
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2010
    Posts
    7

    Pivoting table to get output in 3 adjacent cells where each value is percentage of other

    Hi,

    I have a table as below:

    Name Month Income
    Apple Dec-13 80
    MS Mar-14 40
    Samsung Sep-13 60
    Sony Nov-13 40

    And want output as below.
    Name/Age Aug-13 Sep-13 Oct-13 Nov-13 Dec-13 Jan-14 Feb-14 Mar-14 Apr-14
    Apple 40 80 16
    MS 20 40 8
    Samsung 30 60 12
    Sony 20 40 8

    Please refer attached sheet for more clear data.


    --Loveleen
    Attached Files Attached Files

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,658

    Re: Pivoting table to get output in 3 adjacent cells where each value is percentage of oth

    I don't see any month in your data


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    12-03-2013
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Pivoting table to get output in 3 adjacent cells where each value is percentage of oth

    Pls refer the data below.


    posts.png
    Name Month Income
    Apple Dec13 80
    MS Mar-14 40
    Samsung Sep-13 60
    Sony Nov-13 40
    Name/Age Aug-13 Sep-13 Oct-13 Nov-13 Dec-13 Jan-14 Feb-14 Mar-14 Apr-14
    Apple 40 80 16
    MS 20 40 8
    Samsung 30 60 12
    Sony 20(50% of 40) 40 8 (20% of 40)
    HTML Code: 
    [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE]
    Attached Files Attached Files
    Last edited by Loveleen; 01-13-2014 at 02:33 AM.

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,658

    Re: Pivoting table to get output in 3 adjacent cells where each value is percentage of oth

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

  5. #5
    Registered User
    Join Date
    12-03-2013
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Pivoting table to get output in 3 adjacent cells where each value is percentage of oth

    Please refer the corrected excel sheet and table attached for your reference.

  6. #6
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,658

    Re: Pivoting table to get output in 3 adjacent cells where each value is percentage of oth

    Drag Name and drop it in Row Field
    Drag Month and drop it in Header Field
    Drag Income and drop it in Data Field

  7. #7
    Registered User
    Join Date
    12-03-2013
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Pivoting table to get output in 3 adjacent cells where each value is percentage of oth

    Can u please give some more details.


    Thanks in Advance.

  8. #8
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,658

    Re: Pivoting table to get output in 3 adjacent cells where each value is percentage of oth

    I already provided enough details.

    If you want more then just use google to know how to use Pivot Table

  9. #9
    Registered User
    Join Date
    12-03-2013
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Pivoting table to get output in 3 adjacent cells where each value is percentage of oth

    But how will I get the percentage of value

    When I pivot the table, the income should come in corresponding cells in 2 nd table.
    And the adjacent cells should have % value of that income.

    Example.

    In Nov Sony has income of 40,

    So when I pivot the table it should store 20 (i.e 50% of 40) in Oct, 40 in Nov and 8 (i.e. 20% of 40 ) in Dec.

+ 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. Replies: 3
    Last Post: 01-07-2014, 06:13 AM
  2. Find percentage of times two adjacent cells have the same data
    By jamie_bisson in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 02-26-2013, 01:53 AM
  3. Replies: 2
    Last Post: 03-20-2012, 05:31 PM
  4. Replies: 3
    Last Post: 02-21-2012, 12:14 PM
  5. Replies: 1
    Last Post: 02-27-2009, 03:18 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