Search
Search

# count number of orders entered

Morning all,

I have created a report which divides (calculates) number of orders in x number of days. The report is working perfectly however now I would like to add a new feature in it. For example

```Number of days            Number of Orders
1                                           3
2                                           2
3                                           4
4                                           5
5                                           6
```

The above example shows 3 orders took 1 number of days to be shipped out. Now what I would like to show is, 5 orders (in reality) should have taken 1 number of days. So in my report it will show it like this

```Number of days            Number of Orders        Actual Number of Orders
1                                           3                                   5
2                                           2                                   4
3                                           4                                   7
4                                           5                                   2
5                                           6                                   1
```

The above example shows that in reality in one day 5 orders should have been shipped however only 3 went out.

So in other words I would like to show orders according to when they were entered and match them with the orders which were actually shipped accordingly.

I tried using formula like this

```{date_entered};
distinctcount({order_num});
```

and I put it under the crosstab (Number of days row) however that shows the total number of orders instead of dividing those actual orders into number of days.