Skip to Content

Count Orders on where the Order Came from

I have a report that shows orders and where the order was generated, from a orderset, from a preflist, from a panel, oneoff etc... I want to get a count of the orders that came from these different sources. So 4 of the orders were a oneoff order, 3 were from an orderset and so on. I have tried a running total and some different formulas but they are not working. Thanks in advance.

capture.jpg

capture.jpg (40.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 18 at 07:35 AM

    Hi Curt,

    1. Insert a Crosstab and place it on the Report Header/Footer.

    2. Use the "Order Source" as the Row of the Crosstab.

    3. Use the "Order Number" with a "Distinct Count" summary as the "Summarized Field"

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded