Pivot table Help
 

I have a Pvt Table That looks like the following:
Dept Location Type Level Name

So the pvt is totaling on Dept, Location, Level, and name is listed
individually. The problem is we need to use this setup, but we also want to
be able to get the Level Totaled by Location. Right now Level is totaling
under every Diff Type, which we need but we also want another total under
location. Is this Possible? I can send the file to help with the answer is
someone has an idea on what I mean.

Thanks
Vick