Excel 2010: How to create pivot table using multiple tables [closed]
up vote
0
down vote
favorite
I have three tables each with three column headings:
Table 1 column headings: "Name", "Permission", "Inv" ---
Table 2 column headings: "Name", "Permission", "lim" ---
Table 3 column headings: "Name", "Permission", "cust" ---
I want to make a pivot table such that I have the following fields:
"Name", "Permission", "Inv", "lim", "cust"
So that I can maybe have Inv, lim and cust as subcategories within name and permission, the common fields on all three tables.
How can I achieve this on excel 2010? Please help!
microsoft-excel microsoft-excel-2010 pivot-table
asked Nov 26 at 17:02
hsk
11
closed as off-topic by fixer1234, Twisty Impersonator, bertieb, Pimp Juice IT, music2myear Dec 5 at 17:25
- This question does not appear to be about computer software or computer hardware within the scope defined in the help center.
If this question can be reworded to fit the rules in the help center, please edit the question.
|
show 1 more comment
up vote
0
down vote
favorite
I have three tables each with three column headings:
Table 1 column headings: "Name", "Permission", "Inv" ---
Table 2 column headings: "Name", "Permission", "lim" ---
Table 3 column headings: "Name", "Permission", "cust" ---
I want to make a pivot table such that I have the following fields:
"Name", "Permission", "Inv", "lim", "cust"
So that I can maybe have Inv, lim and cust as subcategories within name and permission, the common fields on all three tables.
How can I achieve this on excel 2010? Please help!
microsoft-excel microsoft-excel-2010 pivot-table
asked Nov 26 at 17:02
hsk
11
closed as off-topic by fixer1234, Twisty Impersonator, bertieb, Pimp Juice IT, music2myear Dec 5 at 17:25
- This question does not appear to be about computer software or computer hardware within the scope defined in the help center.
If this question can be reworded to fit the rules in the help center, please edit the question.
You can try to add all tables to data model.
– Lee
Nov 27 at 9:53
@lee i don't think there is a data model option for excel 2010
– hsk
Nov 27 at 13:56
I mean create PivotTables and check the option add to data model.
– Lee
Nov 28 at 0:41
Yeah that option isn't available in excel 2010, my office has a weird issue where all PCs only have excel 2010, that's why I wanted a solution for excel 2010 only
– hsk
Nov 28 at 10:44
4
I'm voting to close this question as a duplicate of superuser.com/questions/1379248/…
– fixer1234
Nov 30 at 8:02
|
show 1 more comment
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I have three tables each with three column headings:
Table 1 column headings: "Name", "Permission", "Inv" ---
Table 2 column headings: "Name", "Permission", "lim" ---
Table 3 column headings: "Name", "Permission", "cust" ---
I want to make a pivot table such that I have the following fields:
"Name", "Permission", "Inv", "lim", "cust"
So that I can maybe have Inv, lim and cust as subcategories within name and permission, the common fields on all three tables.
How can I achieve this on excel 2010? Please help!
microsoft-excel microsoft-excel-2010 pivot-table
asked Nov 26 at 17:02
hsk
11
I have three tables each with three column headings:
Table 1 column headings: "Name", "Permission", "Inv" ---
Table 2 column headings: "Name", "Permission", "lim" ---
Table 3 column headings: "Name", "Permission", "cust" ---
I want to make a pivot table such that I have the following fields:
"Name", "Permission", "Inv", "lim", "cust"
So that I can maybe have Inv, lim and cust as subcategories within name and permission, the common fields on all three tables.
How can I achieve this on excel 2010? Please help!
microsoft-excel microsoft-excel-2010 pivot-table
microsoft-excel microsoft-excel-2010 pivot-table
asked Nov 26 at 17:02
hsk
11
asked Nov 26 at 17:02
hsk
11
edited Nov 26 at 17:19
asked Nov 26 at 17:02
hsk
11
asked Nov 26 at 17:02
hsk
11
asked Nov 26 at 17:02
hsk
11
11
closed as off-topic by fixer1234, Twisty Impersonator, bertieb, Pimp Juice IT, music2myear Dec 5 at 17:25
- This question does not appear to be about computer software or computer hardware within the scope defined in the help center.
If this question can be reworded to fit the rules in the help center, please edit the question.
closed as off-topic by fixer1234, Twisty Impersonator, bertieb, Pimp Juice IT, music2myear Dec 5 at 17:25
- This question does not appear to be about computer software or computer hardware within the scope defined in the help center.
If this question can be reworded to fit the rules in the help center, please edit the question.
You can try to add all tables to data model.
– Lee
Nov 27 at 9:53
@lee i don't think there is a data model option for excel 2010
– hsk
Nov 27 at 13:56
I mean create PivotTables and check the option add to data model.
– Lee
Nov 28 at 0:41
Yeah that option isn't available in excel 2010, my office has a weird issue where all PCs only have excel 2010, that's why I wanted a solution for excel 2010 only
– hsk
Nov 28 at 10:44
4
I'm voting to close this question as a duplicate of superuser.com/questions/1379248/…
– fixer1234
Nov 30 at 8:02
|
show 1 more comment
You can try to add all tables to data model.
– Lee
Nov 27 at 9:53
@lee i don't think there is a data model option for excel 2010
– hsk
Nov 27 at 13:56
I mean create PivotTables and check the option add to data model.
– Lee
Nov 28 at 0:41
Yeah that option isn't available in excel 2010, my office has a weird issue where all PCs only have excel 2010, that's why I wanted a solution for excel 2010 only
– hsk
Nov 28 at 10:44
4
I'm voting to close this question as a duplicate of superuser.com/questions/1379248/…
– fixer1234
Nov 30 at 8:02
You can try to add all tables to data model.
– Lee
Nov 27 at 9:53
You can try to add all tables to data model.
– Lee
Nov 27 at 9:53
@lee i don't think there is a data model option for excel 2010
– hsk
Nov 27 at 13:56
@lee i don't think there is a data model option for excel 2010
– hsk
Nov 27 at 13:56
I mean create PivotTables and check the option add to data model.
– Lee
Nov 28 at 0:41
I mean create PivotTables and check the option add to data model.
– Lee
Nov 28 at 0:41
Yeah that option isn't available in excel 2010, my office has a weird issue where all PCs only have excel 2010, that's why I wanted a solution for excel 2010 only
– hsk
Nov 28 at 10:44
Yeah that option isn't available in excel 2010, my office has a weird issue where all PCs only have excel 2010, that's why I wanted a solution for excel 2010 only
– hsk
Nov 28 at 10:44
4
4
I'm voting to close this question as a duplicate of superuser.com/questions/1379248/…
– fixer1234
Nov 30 at 8:02
I'm voting to close this question as a duplicate of superuser.com/questions/1379248/…
– fixer1234
Nov 30 at 8:02
|
show 1 more comment
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
You can try to add all tables to data model.
– Lee
Nov 27 at 9:53
@lee i don't think there is a data model option for excel 2010
– hsk
Nov 27 at 13:56
I mean create PivotTables and check the option add to data model.
– Lee
Nov 28 at 0:41
Yeah that option isn't available in excel 2010, my office has a weird issue where all PCs only have excel 2010, that's why I wanted a solution for excel 2010 only
– hsk
Nov 28 at 10:44
4
I'm voting to close this question as a duplicate of superuser.com/questions/1379248/…
– fixer1234
Nov 30 at 8:02