Export to Excel, Group and Sort Summary Layout

L
Larry Cahn 👤 Member for 8 years 6 months

I'm attempting to export to excel a group and sort layout which groups the activities to show grand totals and summaries only. How can I export this to excel in the same layout format I see on my screen?

I've tried multiple ways, but the export keeps every single activity, not in the grouping and summary totals I had set. I'd like to only see the 15 or so rows of grouped activities, not the hundred of lines of every individual activity.

Does anyone know how to do this? Thanks!

M
Mike Hackley 👤 Member for 14 years 11 months

Go to Group and Sort  Check the box that says show summaries only.  Then Copy and paste layout to excel

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts