Total sum for several dimensions

[#1]

I'm using straight table and I have a problem with calculation "Total Qty" - the formula should be sum(Qty) grouped by Code.

Can anyone help me with set analysis formula?

Code	Sub code	Qty	Total Qty
111	a	25	58
111	b	23	58
111	c	10	58
222	a	11	68
222	b	34	68
333	c	23	68

[sujeetsingh]

See this sample may be it help you!!

[kumarnatarajan]

Hi,

i don't know what you expect result. i thought you need total qty in all rows.

use this for total qty for each row

Ex: Sum(TOTAL [Total Qty])

[Gysbert_Wassenaar · Accepted solution]

Try sum(total <Code> Qty)

[er_mohit]

Try this

aggr(sum(Total Qty),Code)

[#6]

try this

Aggr(sum([Total Qty]),Code)