I'm not sure I completely understand what you are trying to achieve. Are you saying that any invoices issued in the first 10 days of the month are for the previous month's sales? What about invoices issued after the 10th of the month? And then you want to total the sales for each sales month?
Try this in your load script:
IF(Day(FechaEmision)<=10,Month(FechaEmision)-1,Month(FechaEmision)) AS SalesMonth
Then, in your charts you could have SalesMonth as a dimension and Sum(SubTotalVentas) as an expression.
Hope this helps,
Hello good day jason.
Regarding your questions asked, here is set court dates is all that is billed. these are the dates
from 01/01/2012 to 02/10/2012 is January, I mean that everything is billed in this period or during cairia in January.
from 11/02/2012 to 10/03/2012 is February, as all that is billed in the period up to February or trancurso
11/03/2012 to 04/10/2012 is the March, like everything that is billed in this period corresponds to March or trancurso
thank you very much
and so I hope I have explained sucesibamente better without but for now I say goodbye and agradesiendo your kindness, I hope to continue to count on your support as I am new to this
HOLA BUEN DIA jASSON
MIRA ESTOY INTENTANDO CON LA FORMULA QUE ME ENVIASTE Y SI ME ES UTIL PERO ME ENVIA EN VES DE ABRIL EL NUMERO "4" Y ME ENVIA UN "0" SIENDO QUE TODAS LAS FACTURAS TIENEN UNA FECHA DE EMISION... ESPERO ME PUEDAS APOYAR CON ESTO GRX
SIN MAS POR EL MOMENTO ME DESPIDO Y QUEDO A TUS ORDES