Record Format formatting/Worksheet help

[MattG]

I am semi new to using worksheets. I have used basic ones I have made, but trying to step it up here looking for some help.

I have a record format that I want to display

-The type of my thing

-The Size of my thing

-The color of my thing

-A label of what group it belongs to

So I made this and applied it to some symbols, but it doesn't display the way I want it to in my report.

My size is a length and when I run the report I summarize items with the same size. However it then is giving me the total size overall. I want to just know a quantity of that certain size that is that certain type as well. Ideally I would like something that Summarized how many of type A at size X, how many of Type A size Y, Type B size X and so forth.

In addition to that I want to have a report of this on my design layer referenced to a number of viewports on various sheet layers displaying that information. I want to have that same report always updating with changes. I know there is something easy I am missing. What is it?

[Pat Stanford]

Take a look at this thread about summing and totaling worksheets.

Pat