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.
Have you tried moving Day(Date) to the level of detail (Detail) shelf?
Become a Viz Whiz on the Forums! Support the Community and master Tableau.