Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Suppress summary of single record?


WayneH

This topic is 7915 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I prepare a Sales report that categorizes each sale into a heirarchy of about 5 levels; eg. sales by city, then state, then country. I'd like to NOT display sub-summaries for any level that contains only one record. When one product goes to one location, say ice to an eskimo, I now have to look at the same data being summarized all the way up the heirarchy; ice to eskimoes, to Alaska, to Alaska and Hawaii, and you get the picture.

Is there a way to hide sub-summaries when there is only one entry?

Link to comment
Share on other sites

  • 1 year later...

What Wayne is asking is pretty clear. He simply doesn't want to see subsummaries for groupings containing only ONE record, because you already know the summary by looking at the record itself.

This is probably possible if you use calculation fields in place of your summary fields. They would somehow check how many records are in the grouping, and if more than one, =the summary field, otherwise blank.

Maybe someone else has an idea about how that calculation might work?

Link to comment
Share on other sites

This topic is 7915 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.