Adding up scheduled quantities

[Tom Krowka]

See image below. Am trying to add quantites of each category together, than add the two categories together to get a grand total. Haven't had much luck.....would appreciate some advice.

Thanks Tom

[sinceV6]

Hello.

From what I can gather from the image:

You need to turn on the SUM option for the measured area field so that AC can add up the values and show you a grand total.

If you wish to have separate business and retail totals in the same schedule, flag the zone category (so it is listed separately), not the measured area.

Hope I understood what you need and that helps.

[Tom Krowka]

ok....am closer. Have the grand total, now need to subtotal each category. Can't figure out how to do that. See pic below.

[sinceV6]

Hi.

Forgot to say (my bad) that zone category should be the first field, so that total groups by category. You will also need to check "show headline" in the schedule settings.

It is currently not grouping because all your elements are different.

Hope that solves the issue. If not, ask again

Best regards.

[Tom Krowka]

That last clue did it. See the image below.

Thanks.