Sum TOTAL by column

[jvargasmayorga]

Hello community.
I have the following query. I am looking to show the total of a calculation in a column.
As you can see in the image I have the column "Year" and "Month", then I have the value of "Fuga" for which I use the following formula

Sum({$<Cod_Estado_Pasaje = {4}>} Cantidad_Transito)

Then in the value of "transito" I want to place the TOTAL of the "fuga" column, for which I use the following formula:

Sum({$<Cod_Estado_Pasaje = {4}>} TOTAL Cantidad_Transito)

But it is adding the total of everything selected, for example it is showing me the total of "Sep" and "Oct" 5637 + 5574 = 11,211

What I need is that in the column of "transit" "Sep" only the value of 5637 is shown

I hope you have let me understand, and I hope you can tell me how to do it

Thanks

Jose

[anat]

aggr(Sum({$<Month=p(Month),Cod_Estado_Pasaje = {4}>} Cantidad_Transito),Month)

[jvargasmayorga]

Thanks for your answer.
Use the formula that you indicated, the correct value of the total is shown, but only to the value of one dimension, my dimension is "Hour" and it is only shown in the value of "00:00". I would like it to be shown in all rows, already that this value is going to be used to get the% of "Fugas".
I hope you can help me

[jvargasmayorga · Accepted solution]

Community, I found the solution, I kept looking for information in this forum. My formula was like this:

Sum({$<Cod_Estado_Pasaje = {4}>} TOTAL <Hora,Mes> Cantidad_Transito)

"Hora" and "Mes" are my dimensions.

REgards.

Jose