in part one we talked about the basics
of creating a pivot table and in this
video we're going to look at report
filters slicers and pivotcharts right
now this pivot table is using data from
all of the salespeople but let's say we
want to remove certain salespeople to
see how their sales impact their regions
we can do that by adding a report filter
just drag the salesperson field into the
report filter area and it will create a
filter in the upper left corner of the
pivot table click the drop down arrow
and click select multiple items and then
just uncheck the ones that you don't
want
I'll uncheck Michael Brennan Richard
doom Lao and Shannon Thompson which will
remove their data from the pivot chart
so it has changed the totals and it's
also hidden the regions for the
salespeople that we removed
if you use filters a lot you might want
to use slicers which were introduced in
Excel 2010 as a faster more interactive
way to filter from the options tab click
insert slicer
and select the field that you want
and now you can just click on individual
salespeople
select several adjacent ones by
clicking-and-dragging
and the PivotTable will instantly update
after each change
to choose several non adjacent ones you
can just hold down the control key on
your keyboard and then click
and lastly I want to tell you a little
bit about pivot charts a pivot charts
are basically the same as regular charts
except they display data from a pivot
table just click any cell in your pivot
table
and then from the options tab click
pivot chart
pick a chart type
and click okay
and now any changes that you make to the
pivottable will show up in the pivot
chart as well and I'm just going to move
these fields around so I can view each
person's sales by month
with a pivot table pivot chart and
slicer we can look at the data in so
many different ways and all without
changing or deleting any of the original
data it's a great way to find the
answers to questions or just to
experiment to discover new things about
the data like what you just saw radix
add a comment subscribe to our Channel
the freedom to learn what you want when
you want
absolutely free
GCF learn free.org