export from P3 into xls including grouping structu

Z
Zhang Haixiang 👤 Member for 21 years 2 months

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)

R
Razi Khan 👤 Member for 21 years 11 months

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

E
Eckart Schenck 👤 Member for 21 years

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

R
Razi Khan 👤 Member for 21 years 11 months

Hi,



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



Cheers.

J
Jaco Stadler 👤 Member for 21 years 9 months

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

Forum Sponsor

Top Posters

Dimitrios Theocharidis
3 posts
MichaelFuelsC
0 posts
anwar zeb
1 posts
olva seselima
1 posts
Muhammd Muneer
0 posts
sairam
0 posts
MARAT BILYALOV
0 posts
RichTea66
0 posts
Muneer Muhammad
1 posts
Manny Onifade
5 posts