How to get % of sales by customer by quarter by year?

[JoeNewton]

Hello,

I have a very basic table with the following:

• Amount of sales ($)
• Date
• Customer

I want to get the percent of total sales of each year that are done by customer, by quarter.

Any help?

Thanks!

[v-luwang-msft]

Hi @JoeNewton ，

Could you share a sample data and expect output result?Each year  by quarter ,not understand detail show according.

Best Regards

Lucien

[JoeNewton]

Sure, a table or matrix showing the following is what I'd like:

2022 total sales

Q1 | Total Sales for Q1 | % of 2022 sales in Q1

Q2 | Total Sales for Q2 | % of 2022 sales in Q2

Q3 | Total Sales for Q3 | % of 2022 sales in Q3

Q4 | Total Sales for Q4 | % of 2022 sales in Q4