Find number of customers during a given period for example YTD versus LY YTD in sheets.
Hi, I have to find number of customers during a given period for example YTD versus LY YTD. I have created variables for ytd and lytd like this ">=$(mindate)<=$(maxdate)" and ">=$(lmindate)<=$(lmaxdate)" respectively.
Customers are denoted by [Customer Number]. How can I achieve the results in UI and which chart, I should prefer for this.
Thanks & Regards, Please Accepts as Solution if it solves your query.
