Welcome to PCO Blogs

This is a place for Registered Users to share their technical view and opinions in form of blogs which they think might be useful to the greater PCO community. We invite prolific writers to share their insights and witticisms, but remind all contributors to be mindful of any copyright rules. ProjectControlsOnline will not be held responsible for any breach in rights and responsible users will be held accounted for the same.

Please note that you may NOT get badges, stars etc. by posting blogs here as they are pretty meaningless as they do NOT make you wealthier, fitter or more attractive to the opposite sex! The best you will get from contributing here is the satisfaction/self-respect from knowing you have helped others.  So, please continue to make positive contribution to this community portal and extend whatever help you can to your fellow colleagues.  Thanks!


Please read this help page before creating a blog

Latest blog entries

Export data to Excel with "lowest level" summary data only

Jun 21

Written by:
21/06/2016 21:33  RssIcon

Export data to Excel with “lowest level” summary data only


You create an Activity code to group data as you wish. After assigning and grouping activity by Activity code, here is the result:


You want to export only the summary data to excel. So we will tick the “Show Summaries Only” option.


However, you only want to export summary data at the lowest level. Because if you export all level, then in excel if you sum the value, it is a wrong number.

So, how can we show only summary data at the lowest level. The “high level” summary data should be zero.

Here is the solution.

In the Group & Sort dialog, you deselect the “Indent” option:


Now the summary data only appear at lowest level:



Your name:
Gravatar Preview
Your email:
(Optional) Email used only to show Gravatar.
Your website:
Security Code
Enter the code shown above in the box below
Add Comment   Cancel 
Search Blogs