I'm trying to show the average sales per work day.

I managed to create the calculation by calculating a running total of the sales for the month and dividing it the the by the number of workdays up til this point.

This all works fine. but I want to show the results side by side and not in 2 rows.

When I remove the day pill, the calculation stops working.

Here is my calculation:

running_sum(SUM([invoice_line_tbl (sales.invoice_line_tbl) (rsdbbiprototype) Extract].[adjusted_pounds]))/sum(zn([daycount]))

which works fine as long as I display the day on the row shelf.