How to make a chart that calculates total sales by payment meothd?
I have a sales sheet indicating many information among of which is the total of each sale and the payment method (either cash or cheque).
I made a report to group only sales from this month, with both payment methods, I wanted to add a widget to the dashboard from this report that will show total sales by cash and total sales by cheque and then the Total of both in a simple chart. However the chart shows all individual sales in a large and messy way.
I don't know if there's a way to fix that or if I need more steps before creating the widget.
any help is appreciated