export from P3 into xls including grouping structu
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
What you need to do is just sort your activities then add a group title.
if you have too many to add, try excels outline worksheet function.( Im using excel 2002,it has the ability to group rows/columns)
Is web publish is an alternative?
Then why dont you give report in pdf format instead of Excel.
Im familiar with sorting by act codes in xls.
The problem comes when you communicate with somebody who doesnt know well the act code structure and doesnt have P3 either. In such case it would be good to have an excel export with the grouping...
Heinz
Hi,
Export with "Activity Code" Columns also and then sort and group in Excel as per requirement.
Cheers.
Henk Export the Activity Codes as Well then when you are in XLS you just sort or Subtotal By Structure