Group totals

[KBChristy]

I am trying to create a grand total based on a group total which has selection criteria against it. Can someone please help me in doing this?

Thanks

 

[rosemaryl]

KBChristy,

A more detailed explanation is required, maybe with some example data, describing what you need before I can assist you.

ro
Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[dgillz]

You should just be able to right click the detail field you want grand totals and select "insert grand total". The group selection formula will sort out the groups you do not want and return the proper totals. Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[rosemaryl]

Hey Dgillz,

I wasn't quite sure here what he/she meant.

A very early good morning, by the way.

ro Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[KBChristy]

Sorry for not being more precise. The problem with creating a sub-total on the field is that it always totals on this field. I have a selection criteria which specifies whether summary or detailed data is required. That's the problem - I need to be able to sub-total on either the detail or the summary (whatever has been selected) but it doesn't seem to work. I seem only to be able to sub-total on one or the other regardless of the selection criteria selected.

 

[rosemaryl]

kbchristy,

Could you please show some example data? Also, when you say selection criteria, do you mean you have a parameter? Or are you conditionally suppressing information?

Maybe a layout of what you are expecting given each scenario would be helpful,

ro Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[dgillz]

You cannot subtotal a summary field. You can only subtotal a detail field.

Please explain what it is you are looking for, as Rosemary suggested. Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[KBChristy]

Thanks for your help (& confusing you all!) but I have managed to sort it by using manual running totals.