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]))
