export from P3 into xls including grouping structu

Henk Export the Activity Codes as Well then when you are in XLS you just sort or Subtotal By Structure

Hi,

Export with "Activity Code" Columns also and then sort and group in Excel as per requirement.

Cheers.

I’m familiar with sorting by act codes in xls.

The problem comes when you communicate with somebody who doesn’t know well the act code structure and doesn’t have P3 either. In such case it would be good to have an excel export with the grouping...

Heinz

Then why don’t you give report in pdf format instead of Excel.

Is web publish is an alternative?

What you need to do is just sort your activities then add a group title.

if you have too many to add, try excel’s outline worksheet function.( I’m using excel 2002,it has the ability to group rows/columns)