This content has been marked as final. Show 4 replies
This should be simple, but I am running into complications. Hopefully I am just missing something obvious.
I want to take a list of sales orders (below) and create a table (below) summarizing each type of order. The revenue line is easy by itself, but % of revenue and customer count are causing problems.
I tried creating sets to filter the order types, but had trouble with multiple sets filtering the data.
Also, I tried creating different tabs for each order type and stitching them together in a dashboard.
Any help is appreciated.