Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

tricky pivot table scenario

Posted on 2014-03-05
5
Medium Priority
?
284 Views
Last Modified: 2014-03-05
Hi expert's excel 2007

is it possible to take certain values from col b and certain values from col c and create a pivot table..where the user can pick and choose which vlues they want to show.

Table A
Col A.                Col B.                Col C
Abc.                     24.                    7
Dcf.                      12.                   10
Tgfd.                     9.                     57
Ytu.                       6.                     53
Ott.                       44.                  19
Yuu.                      52.                  11

Pivot Table
Labels.          Result
Abc.               24.     Take from col b
Dcf.               10.      Take from col c
Tgfd.               9
Ytu.                6
Ott.                19
Yuu.               52
0
Comment
Question by:route217
5 Comments
 
LVL 85

Assisted Solution

by:Rory Archibald
Rory Archibald earned 1000 total points
ID: 39906199
Not without a separate column of data that the pivot table can use. (I don't really see the connection to a pivot table in your example, but assume it's simplified)
0
 

Author Comment

by:route217
ID: 39906229
So separate column...it the best route...I am using pivot table because of the volume of data...
0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 39906382
I think so, yes.
0
 
LVL 8

Accepted Solution

by:
5teveo earned 1000 total points
ID: 39906407
change the original data relationship to       something like

Name      Col      Value
Abc      ColB      24
Dcf      ColB      12
Tgfd      ColB      9
Ytu      ColB      6
Ott      ColB      44
Yuu      ColB      52
Abc      ColC      7
Dcf      ColC      10
Tgfd      ColC      57
Ytu      ColC      53
Ott      ColC      19
Yuu      ColC      11

Offers building Pivot table that will allow you to click on columns you choose...
ExcelChart.png
0
 
LVL 34

Expert Comment

by:Rob Henson
ID: 39906615
What is the theory/logic behind which column to choose?

With the option above, you can choose "Col B for All values" or "Col C for All values" or "Both for All values" not a combination of Col B for some and Col C for others.

If you can formulate the logic for which value to choose and put that into a column, you can then reference that column instead.

Thanks
Rob H
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

886 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question