Skip to main content

Hello Everyone,

 

I am trying to create an Index value using the Grand Total value and not able to find a way to do this.

 

I have a database of actual sales by sku by week. For each week (I can have same week for multiple years), I want to create an index to see seasonality. For that, I created a row calculation showing average/week for each week. Now I want to divide this value by the Grand Total value (which is average of all the weeks that are selected in the table). I am not sure how to do this. I am attaching the work table for reference.

 

Objective : Create the "Index" field which I can do fairly easily in Excel but can't figure it out in Tableau. I am attaching my Excel workbook.

 

Any help will be appreciated.

8 answers
0/9000