Forum Discussion
Pivot table - showing text value and multiple charts
Calleigh-Marie-
Maybe try something like the attached file. You need to put the Pivot Table in Tabular Format (This is on the PivotTable Tools Tab > Layout > Report Layout (far left). Another option is to double click the counts. This will drill to the detail behind the summary figure.
Hi Matt,
That's really useful and actually really helped with what I was doing :) Thank you, I appreciate it. Could I ask for your expertise on another stumbling block?
I'd like to use the splicer to separate out topics. Issue is, many of the mailings/events above cover multiple topics c. e.g. Walking Challenge EDM could come under 'wellbeing' and 'volunteering'. As below:
What I'd like to be able to do is have a splicer with a list of all the individual topics and be able to select multiple from that to show for example, all mailings including wellbeing as a topic. So the aforementioned example, would come up in a splice for both wellbeing and volunteering. Does that make sense? I'd like my splicer to look like this:
Currently under topics I'm having to type "Fundraising & Volunteering", "Fundraising & Other" etc. which isn't ideal when you see the Splicer.
Thanks in advance!!!!
Hey, happy that the previous file I provided was able to help you out a bit. I understand what you would like to do based on your description, however I don't think what you want is possible without modifying the data structure. I'm attaching the updated file for your reference (See attached). I believe you could do a few different things:
1. Before Worksheet: Use the Ctrl Key to filter on multiple selections within the slicer
2. After Worksheet: Modify the data to contain 1 row for each category.... i.e. a Fundraising and Volunteering record would become two records one for Fundraising and one for Volunteering. For a clear example please refer to the example file.
Hope this helps.