How to find out number of times a customer ordered with Pivot Table

Hi,

I would like to know how to find out how many times a customer ordered using the Pivot Table in Microsoft Excel. I have a set of data (attached) that includes the following columns:

• Order_No
• Customer
• Phone
• SP
• SP_info
• Date
• Item
• Qty
• base_price
• actual_charge
• Total

Now, in the data, there is a separate line for each item purchased with the same order ID, date, and time. So, I have been trying to get a Pivot Table that will only give me the distinct count for the Customer column according to the date. For Example, a customer named Kelly Fay Rodriguez Ordered only 2 times (2/1/ 2020 & 2/18/2020) throughout the month, and I want a pivot table with 2 columns that provide me unique customer names and a number of times orders, in this case, the result would be 2.

So, I was hoping if there is any way to get the desired result in the pivot table without typing any formulas?

Your assistance would be highly appreciated. TIA

Regards,

Mehdi

Thanks for the help, it worked like a charm!