Totales for dimensión :(

[Daniboy2019]

Hello, good afternoon, could someone help me with the following detail. When selecting the dimension of Estación Aguascalientes, it gives me a profit of 1.80 for the month of January, and it is correct, what I need to do is that the same data is maintained when selecting another dimension, for example, Eagle, and that it shows , Aguascalientes utility 1.80 and Aguila Utility 2.40, and what it currently does here is that it gives me other states that are not its total by dimension 😞

this is my formula

=Sum(Total <Estacion>
Aggr(
(Sum(CantidadR) / Sum(total CantidadR))
*
((((Avg(PrecioR)-ieps)/UIva+ieps)
-
///Costo Factura
Sum(Aggr(((
(Sum(Costo2) - Sum( ieps ) ) -Sum([UFlete Mexicali-GDL]) ) /UIva)
+
Sum(ieps),Fecha,Estacion, Producto)
)
//////////

-
Aggr(Sum ([UCostoAditivo]), Fecha,Estacion, Producto)
-
(Avg((PrecioR)/UIva))
*
Sum([UImpuestoEstatal]))+Sum (UIncentivoFiscal)), Fch, Estacion, [ProductoID-ProductoID]))

[neerajthakur]

Try this 

Sum(Total {1}<Estacion>
Aggr(
(Sum(CantidadR) / Sum(total CantidadR))
*
((((Avg(PrecioR)-ieps)/UIva+ieps)

Use set modifier 1

Study more about this on QlikSense Documentation Page 

[Daniboy2019]

Thank you 🙂 

[neerajthakur]

Hi @Daniboy2019 if it helped you please accept it as solution