Sum a Group By Sum Field

[adrianvasile]

I have a simple query that manages some pricing information and I will need to have a total of a Group By Sum field.
Basically it will list each price that an item had, the cost associated and the quantity sold. I will use a Group by Sum for the Qunatity to get the total quantity for each change in price - but then I will need the total items sold.
Is this possible?
Thank you.

 

[SkipVought]

Hi,

The your agregator is COUNT...

Select Count(*), [SumField] 
From [YourTable] 
Group By [SumField]

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[adrianvasile]

I am using the Query design. How will I do this then?

 

[SkipVought]

Right click in the grid and select TOTALS.

Drag your sum field into the grid and select GroupBy in the TOTAL row.

Drag the field you want to count and select COUNT in the TOTAL row.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

...oops

in the SECOND field...

enter Count(*)

and in the TOTALS row select expression

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[adrianvasile]

I will try it and let you know.
Few minutes please.
Thank you.