Jump to content

Is there a way to show the record number within a sub summary? I have created a report with this type of layout: Type A Company C, Avg: 5 Company B, Avg: 4.7 Company D, Avg: 3.2 Type B


Clinton

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

Recommended Posts

Is there a way to show the record number within a sub summary?

I have created a report with this type of layout:

Type A

Company C, Avg: 5

Company B, Avg: 4.7

Company D, Avg: 3.2

Type B

Company A, Avg 4.9

Company E, Avg 2.4

Type C

...

...

The Type and Company are both sub summaries when sorted by Type and Company, respectively. I do not have a body; I wasn't interested in displaying each individual record, but they do drive the calculation for the Avg for each company.

That report displays exactly how I wanted it, but now I would like to add a Company's "rank" by enumerating what order they show up inside each Type. So, I want the report to look like this:

Type A

1 Company C, Avg: 5

2 Company B, Avg: 4.7

3 Company D, Avg: 3.2

Type B

1 Company A, Avg 4.9

2 Company E, Avg 2.4

Type C

...

...

Any suggestions? Notice how i want it to reset after each Type sub summary... and also, there may be multiple records (though not displayed, since i'm not using a body) per each Company sub summary.

I feel like this should be built-in, somewhere... but i can't seem to find out how to do it.

Link to comment
Share on other sites

This topic is 6203 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.