Pivot tables on pivot tables!

  • Thread starter Thread starter tomo999
  • Start date Start date
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?
 
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.
 
Back
Top