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
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
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)
Last edited by Loveleen; 01-13-2014 at 02:33 AM.
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
Please refer the corrected excel sheet and table attached for your reference.
Drag Name and drop it in Row Field
Drag Month and drop it in Header Field
Drag Income and drop it in Data Field
Can u please give some more details.
Thanks in Advance.
I already provided enough details.
If you want more then just use google to know how to use Pivot Table
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks