Forum Discussion
Summing Customer Sales
Hi, I'm trying to make a report that has customer sales. the data used is by individual invoice lines with Customer Number, Customer Type, Invoice filter by year, and total invoice amount. the total...
thank you for the reply. i'm starting with many lines of individual sale data, many of them multiple purchases, i guess i'm trying to figure out if Power Bi can sum and sort them like a pivot table to make a visual. or do i have to start with data totals already?
Hi cspanek,
You can try to use matrix visual, but it not support column header filters and sort by multiple columns.
Regards,
Xiaoxin Sheng