Forum Discussion
Pivot table
I have a basic skills table .I wish to show how many years I have had a skill for this information doesnt show on pivot table
Also the pivot table shows distribution of skills but some are split over two skills which are the same eg
| Difficult conversations |
is split as
Difficult conversations 2
Difficult conversations 1
Difficult conversations 3
How can I fix this ?
First of all, the Pivot Table isn't the problem. It's doing what it's programmed to do, with the data you give it. YOU read, as do I, as do most people, Difficult Conversations 1, 2 and 3 as basically the same thing. But Excel is more precise: they're different.
That's the only example you give, but if it's representative of your data, it's your data that need to be "clarified," so that Excel--which sadly can't read our minds yet (that's the next generation of AI)(kidding)--can discern what you're thinking.
What I'd do, if I were in your shoes, assuming you want to still be able--for your own reasons--to differentiate between instance 1, instance 2, instance 3 (etc.) is to create a "helper column" in which you just write "Difficult Conversations". OR, if 1, 2, and 3 actually refer to a skill (which, for the record, "Difficult Conversations" is not; it's a circumstance or instance); so if you are meaning to refer to an actual skill you might differentiate by actually naming the skill being employed. For example
- Active Listening
- Diagnostic Questioning
- Grief Counseling
- Etc
Bottom line: it's your data that needs to be made more specific and clear. Then the Pivot Table can work its miracles.
1 Reply
First of all, the Pivot Table isn't the problem. It's doing what it's programmed to do, with the data you give it. YOU read, as do I, as do most people, Difficult Conversations 1, 2 and 3 as basically the same thing. But Excel is more precise: they're different.
That's the only example you give, but if it's representative of your data, it's your data that need to be "clarified," so that Excel--which sadly can't read our minds yet (that's the next generation of AI)(kidding)--can discern what you're thinking.
What I'd do, if I were in your shoes, assuming you want to still be able--for your own reasons--to differentiate between instance 1, instance 2, instance 3 (etc.) is to create a "helper column" in which you just write "Difficult Conversations". OR, if 1, 2, and 3 actually refer to a skill (which, for the record, "Difficult Conversations" is not; it's a circumstance or instance); so if you are meaning to refer to an actual skill you might differentiate by actually naming the skill being employed. For example
- Active Listening
- Diagnostic Questioning
- Grief Counseling
- Etc
Bottom line: it's your data that needs to be made more specific and clear. Then the Pivot Table can work its miracles.