How to get the correct sum

[#1]

Hello all.

I need to get a table of values with each row containing a column with the sum for the family in the respective month and another column with the sum for all families within the month.

Example:

Month	Family	Sum	Sum(2)
Jan	Meat	10	25
Jan	Fish	5	25
Jan	Vegetables	10	25
Feb	Meat	15	32
Feb	Fish	7	32
Feb	Vegetables	10	32

I can get the values for "Sum", but i don't know how to do it for "Sum(2)".

Can anyone help?

Thank you.

Joaquim

[stephencredmond · Accepted solution]

Hi,

Use this:

Sum(TOTAL<Month> ValueField)

Regards,

Stephen

[#3]

Thank you Stephen.

It was simple as that.

Joaquim