I am looking to build segment for all users who have more than 10 visits every month for the last 6 months AND order value is > 1M every month for the last 6 months.
Month starts on 1st every time. Month does not start when user places an order or so.
Please help in building the segment.
I have tried making the segment according to your definition for 3 months. Please have a look at the screenshot. You can go ahead and extend it for 6 months and see if it gives you the desired result.