compare the min date sales value of a filtered month with all other days

[AnilGudap666]

Dear All,

              I am trying to compare the min date sales value of a filtered month with all other days of the selected month. If the sales happened on may 03 the sales value should be compared with may 03 and all other days of may.

Date	Sales	Min Date Sales	% diff with Min dales sales
may 01	0	0	0%
may 02	0	0	0%
may 03	300	300	100%
may 04	150	300	-50%
may 05	450	300	150%
may 05	600	300	200

With filters applied on customer id, and month. 

Please help me with above senario.  

[Anonymous]

Hi @AnilGudap666 ,

I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting and desensitized example data.

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_Binbin Yu