4 Replies Latest reply on Oct 11, 2017 10:16 AM by Sherzodbek Ibragimov

    Summary Table for Order Data

    todd peikin

      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.