Reply
Member
Posts: 87
Registered: ‎05-25-2016

sales amount difference between two dates

Hi, everyone

 

I have this scenario.

Captura.JPG

I would like to create a measure with sales amount between fecha registro and when a month begins reset to 0.

 

The result would be something like this.

 

                                                            Month(Mes)

      Posting date (fecha registro)                 6                   7

      -------------------------------

       09/05/2016                                     10437             11028

       16/05/2016                                     + 116            +     50  

       23/05/2016                                     +     6            -      12 

       30/05/2016                                     +   28            -      36

 

Is there any way to do that?. Assuming there is a way to do it, can I show %difference too?.

 

Any suggestion will be appreciated.

 

Thanks,