Pivot tables on pivot tables!

T

tomo999

Is there anyway of setting the data of a pivot table, on the results of
another pivot table (and not just the original data)?

I know this may seem a bit of a confusing question but basically I'm
trying to use Excel to analyse a log file of all our users on our
computer network and which security groups they belong to. The data
isn't in a brilliant structure so I was going to use a pivot table to
set which users I wanted to be displayed, and then use a second pivot
table to drill down further based on those results (I've tried it in a
single table and it won't work).

Anyone?
 
R

Roger Govier

Hi

On your Pivot table, double click on the Total for the Row or Colum of the
Group you want.
This will open another sheet with all of the transactions making up that
total.
Carry out a Pivot on this subset of data.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top