Under 15 | Standard Delivery | Total customer - 2 Total orders - 3 total revenue - £18 AOV - £9 Tracked Delivery | Total customer - 2 Total orders - 2 total revenue - 25 AOV - 12.50
So I have created table and loaded all columns . now I am trying to do same here where I can get how many distinct customers , how many orders , total revenue ,average order value got two filters under £15 orders should be grouped and filtered and over £15 in another ?? how do get there ..set analysis ...help please.