Pivot table detail [on hold]
I'm using Pivot table for the first time.
How can I filter out customer no, e.g., CUSTOMER A no.12345. Then there's also a CUSTOMER A but with a different no 78910.
pivot-table
edited Jan 10 at 7:50
fixer1234
18.1k144681
put on hold as unclear what you're asking by fixer1234, n8te, music2myear, LotPings, Moses 2 days ago
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
add a comment |
I'm using Pivot table for the first time.
How can I filter out customer no, e.g., CUSTOMER A no.12345. Then there's also a CUSTOMER A but with a different no 78910.
pivot-table
edited Jan 10 at 7:50
fixer1234
18.1k144681
put on hold as unclear what you're asking by fixer1234, n8te, music2myear, LotPings, Moses 2 days ago
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
We did a little polish on your question, but what you're asking isn't clear. You give a verbal example, but it doesn't match your image. I'm guessing that theno 12345andno 78910refer to the numbers in the first column. Is that correct? Can we assume those are text values with leading zeros as part of the value? What do you mean by "filter out"? Do you want them included, excluded, or just differentiated? What are you trying to do in the pivot table? Can you add a screenshot of that? (cont'd)
– fixer1234
Jan 10 at 7:59
If it isn't doing what you want, mock up the desired result and add a screenshot of that. For people to understand the problem, we need what the source data looks like, including an example of the problem condition. Then the output should show how that example would be handled.
– fixer1234
Jan 10 at 7:59
add a comment |
I'm using Pivot table for the first time.
How can I filter out customer no, e.g., CUSTOMER A no.12345. Then there's also a CUSTOMER A but with a different no 78910.
pivot-table
edited Jan 10 at 7:50
fixer1234
18.1k144681
I'm using Pivot table for the first time.
How can I filter out customer no, e.g., CUSTOMER A no.12345. Then there's also a CUSTOMER A but with a different no 78910.
pivot-table
pivot-table
edited Jan 10 at 7:50
fixer1234
18.1k144681
edited Jan 10 at 7:50
fixer1234
18.1k144681
edited Jan 10 at 7:50
fixer1234
18.1k144681
edited Jan 10 at 7:50
fixer1234
18.1k144681
edited Jan 10 at 7:50
fixer1234
18.1k144681
18.1k144681
asked Jan 10 at 7:37
user983271
put on hold as unclear what you're asking by fixer1234, n8te, music2myear, LotPings, Moses 2 days ago
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
put on hold as unclear what you're asking by fixer1234, n8te, music2myear, LotPings, Moses 2 days ago
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
We did a little polish on your question, but what you're asking isn't clear. You give a verbal example, but it doesn't match your image. I'm guessing that theno 12345andno 78910refer to the numbers in the first column. Is that correct? Can we assume those are text values with leading zeros as part of the value? What do you mean by "filter out"? Do you want them included, excluded, or just differentiated? What are you trying to do in the pivot table? Can you add a screenshot of that? (cont'd)
– fixer1234
Jan 10 at 7:59
If it isn't doing what you want, mock up the desired result and add a screenshot of that. For people to understand the problem, we need what the source data looks like, including an example of the problem condition. Then the output should show how that example would be handled.
– fixer1234
Jan 10 at 7:59
add a comment |
We did a little polish on your question, but what you're asking isn't clear. You give a verbal example, but it doesn't match your image. I'm guessing that theno 12345andno 78910refer to the numbers in the first column. Is that correct? Can we assume those are text values with leading zeros as part of the value? What do you mean by "filter out"? Do you want them included, excluded, or just differentiated? What are you trying to do in the pivot table? Can you add a screenshot of that? (cont'd)
– fixer1234
Jan 10 at 7:59
If it isn't doing what you want, mock up the desired result and add a screenshot of that. For people to understand the problem, we need what the source data looks like, including an example of the problem condition. Then the output should show how that example would be handled.
– fixer1234
Jan 10 at 7:59
We did a little polish on your question, but what you're asking isn't clear. You give a verbal example, but it doesn't match your image. I'm guessing that the
no 12345 and no 78910 refer to the numbers in the first column. Is that correct? Can we assume those are text values with leading zeros as part of the value? What do you mean by "filter out"? Do you want them included, excluded, or just differentiated? What are you trying to do in the pivot table? Can you add a screenshot of that? (cont'd)– fixer1234
Jan 10 at 7:59
We did a little polish on your question, but what you're asking isn't clear. You give a verbal example, but it doesn't match your image. I'm guessing that the
no 12345 and no 78910 refer to the numbers in the first column. Is that correct? Can we assume those are text values with leading zeros as part of the value? What do you mean by "filter out"? Do you want them included, excluded, or just differentiated? What are you trying to do in the pivot table? Can you add a screenshot of that? (cont'd)– fixer1234
Jan 10 at 7:59
If it isn't doing what you want, mock up the desired result and add a screenshot of that. For people to understand the problem, we need what the source data looks like, including an example of the problem condition. Then the output should show how that example would be handled.
– fixer1234
Jan 10 at 7:59
If it isn't doing what you want, mock up the desired result and add a screenshot of that. For people to understand the problem, we need what the source data looks like, including an example of the problem condition. Then the output should show how that example would be handled.
– fixer1234
Jan 10 at 7:59
add a comment |
1 Answer
1
active
oldest
votes
In the popup toolbar that usually shows on the right when you create the Pivot Table (titled "Pivot Table Fields") there are 4 boxes on the bottom.
The top-leftmost of these boxes is "Filters". Drag the "customer no" field name to this box, and then you will see, above the pivot table content on the sheet, a line for filtering by "customer no".
Note that you can't use the same field for filtering and Rows or Summed. So if the "customer no" field is part of the data in your pivot table (i.e. in the Rows box), you should see a down-arrow with a drop-down on the summary line at the top, letting you filter that field.
answered Jan 10 at 18:43
DebraDebra
3,85011021
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
In the popup toolbar that usually shows on the right when you create the Pivot Table (titled "Pivot Table Fields") there are 4 boxes on the bottom.
The top-leftmost of these boxes is "Filters". Drag the "customer no" field name to this box, and then you will see, above the pivot table content on the sheet, a line for filtering by "customer no".
Note that you can't use the same field for filtering and Rows or Summed. So if the "customer no" field is part of the data in your pivot table (i.e. in the Rows box), you should see a down-arrow with a drop-down on the summary line at the top, letting you filter that field.
answered Jan 10 at 18:43
DebraDebra
3,85011021
add a comment |
In the popup toolbar that usually shows on the right when you create the Pivot Table (titled "Pivot Table Fields") there are 4 boxes on the bottom.
The top-leftmost of these boxes is "Filters". Drag the "customer no" field name to this box, and then you will see, above the pivot table content on the sheet, a line for filtering by "customer no".
Note that you can't use the same field for filtering and Rows or Summed. So if the "customer no" field is part of the data in your pivot table (i.e. in the Rows box), you should see a down-arrow with a drop-down on the summary line at the top, letting you filter that field.
answered Jan 10 at 18:43
DebraDebra
3,85011021
add a comment |
In the popup toolbar that usually shows on the right when you create the Pivot Table (titled "Pivot Table Fields") there are 4 boxes on the bottom.
The top-leftmost of these boxes is "Filters". Drag the "customer no" field name to this box, and then you will see, above the pivot table content on the sheet, a line for filtering by "customer no".
Note that you can't use the same field for filtering and Rows or Summed. So if the "customer no" field is part of the data in your pivot table (i.e. in the Rows box), you should see a down-arrow with a drop-down on the summary line at the top, letting you filter that field.
answered Jan 10 at 18:43
DebraDebra
3,85011021
In the popup toolbar that usually shows on the right when you create the Pivot Table (titled "Pivot Table Fields") there are 4 boxes on the bottom.
The top-leftmost of these boxes is "Filters". Drag the "customer no" field name to this box, and then you will see, above the pivot table content on the sheet, a line for filtering by "customer no".
Note that you can't use the same field for filtering and Rows or Summed. So if the "customer no" field is part of the data in your pivot table (i.e. in the Rows box), you should see a down-arrow with a drop-down on the summary line at the top, letting you filter that field.
answered Jan 10 at 18:43
DebraDebra
3,85011021
answered Jan 10 at 18:43
DebraDebra
3,85011021
answered Jan 10 at 18:43
DebraDebra
3,85011021
answered Jan 10 at 18:43
DebraDebra
3,85011021
3,85011021
add a comment |
add a comment |
We did a little polish on your question, but what you're asking isn't clear. You give a verbal example, but it doesn't match your image. I'm guessing that the
no 12345andno 78910refer to the numbers in the first column. Is that correct? Can we assume those are text values with leading zeros as part of the value? What do you mean by "filter out"? Do you want them included, excluded, or just differentiated? What are you trying to do in the pivot table? Can you add a screenshot of that? (cont'd)– fixer1234
Jan 10 at 7:59
If it isn't doing what you want, mock up the desired result and add a screenshot of that. For people to understand the problem, we need what the source data looks like, including an example of the problem condition. Then the output should show how that example would be handled.
– fixer1234
Jan 10 at 7:59