Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have this extension that shows sales of certain year, month and deending on it's origen, it works fine:
Sum ({<Y = {"$(=[Año columna 1])"} , M = {"$(=[Hasta mes])"}, Origen = {"$(=[Origen 1])"}>}[Venta Neta Factura])
Now I want to add another dimension with YTD sales so I 've tried this, just adding <:
Sum ({<Y = {"$(=[Año columna 1])"} , M = {"$(<=[Hasta mes])"}, Origen = {"$(=[Origen 1])"}>}[Venta Neta Factura])
but it retruns 0
Has it somethingto do with a format problem??? M is a number, form 1 until 12...
Try
Sum ({<Y = {"$(=[Año columna 1])"} , M = {"<$(=[Hasta mes])"}, Origen = {"$(=[Origen 1])"}>}[Venta Neta Factura])
Try
Sum ({<Y = {"$(=[Año columna 1])"} , M = {"<$(=[Hasta mes])"}, Origen = {"$(=[Origen 1])"}>}[Venta Neta Factura])
Bingo, actually I needed
Sum ({<Y = {"$(=[Año columna 1])"} , M = {"<=$(=[Hasta mes])"}, Origen = {"$(=[Origen 1])"}>}[Venta Neta Factura])
but you respeonse did it!
Great! You just saved me several hours or trying... Maybe I should read some manuals because I should control better these problems...