4 Replies Latest reply on Aug 30, 2016 9:26 AM by Gemma Francisco

# Running Total/Grand Total Calculations

Hi everyone!

I've been using Tableau for a few months, and this is my first time posting a question. I hope it makes sense!

I'm trying to create a report to show the average number of items sold by day and location. I'd like to use the Running Total feature to calculate the average. For instance, on the second day of the month, I'd like to total the items sold from the first and second days and divide it by the number of days that have elapsed.

Unfortunately, I'm having trouble with the Running Sum Grand Total because it's summing across the table as well as down the table.

Some days are not full working days: Saturday is a half day, and we are closed on Sundays and holidays, so I am also using a Running Sum of 'working days.'

I found that if I remove Location from the columns, the Daily Average Sold calculates correctly because the Running Total isn't getting summed across two different locations. I think I can somehow piece these two worksheets together on a dashboard, but is there a different/better way to go about this?

I picked tacos at the item because it's almost lunch time!

• ###### 1. Re: Running Total/Grand Total Calculations

I'm not sure I understood your request correctly or not, but here is my approach.

Change the Measure of Working day.

Change the formula of DAily Avg Sold

Thanks,

Shin

• ###### 2. Re: Running Total/Grand Total Calculations

Hi Shin!

Thank you so much for helping me out. Your solution works, but I’d like to find a way for the running sum works for the totals also. Ideally, I’d hide all of the data for the week and show it on a dashboard with the Tacos Sold by Day worksheet.

Incorrect Grand Total/Subtotal:

This is what I’d like the report to look like with the correct numbers:

This is what it looks like using the current solution. Is there any way to turn it into the solution I want?

Thanks again!

Gemma

• ###### 3. Re: Running Total/Grand Total Calculations

Gemma,