2 Replies Latest reply on Jun 18, 2019 7:13 AM by Saumya Parekh

# Inter Column Running Calculations

Hello,

I'm relatively new at using tableau and still not familiar how to use a lot of it's functions.

I want to do an running calculation across the columns(Date) and Rows

In the attached mock up file Inventory is only available for the first week and i need to calculate it for the rest of the weeks .

The Inventory on 20 June + Supply on 27 June - Base Demand on 27 June -Additional Demand on 27 June to get the Inventory of 27 June.

Then use the Inventory Value of 27 June and all the other values on 4 July(like above) to get the Inventory value for the 4th of July and so on.

To get results in inventory like below.

Rows20 June 201927 June 20194 July 201911 July 201918 July 2019

Supply

100100100100
Base Demand808080

80

Inventory500460480500520
WOC

Also, Once the inventory is calculated I also want to know how can I write to calculation for the weeks of cover (WOC) field.

I want to create a count based WOC such that I can see for how many weeks the inventory in a given week can sustain the total demand (base + additional).

A packaged workbook is also attached to this,

Thanks!

• ###### 1. Re: Inter Column Running Calculations

Hi Saumya,

As per my understanding of the above mentioned problem statement, I have tried to build the desired result.

You can check the attached packaged workbook, I hope it will be helpful for you.

Regards,

Sayali

1 of 1 people found this helpful
• ###### 2. Re: Inter Column Running Calculations

Hey Sayali,

Thanks for the help!

The Inventory calculation is absolutely perfect! and thanks for that!

In the WOC calculation it's my fault that i wasn't clear enough because the inventory was the priority.

Umm i guess what you have done is divide the inventory for that date with the total demand for that day.

I am trying to create something more on the lines of calculating WOC based on the future demand forecast.

MrExcel Message Board This link is similar to what i'm using right now in my excel files

MrExcel Message Board For that I am using a version of the formula shown here.