1 Reply Latest reply on Nov 27, 2018 11:35 AM by Patrick A Van Der Hyde

# Multiple Table Calculations - differences between dimensions and years

I need to create 3 separate table calculations, which I have created in excel. I am struggling to do this in Tableau..

I have one measure, which I

* split as % of total

* then calculate actual difference between years and dimensions

* then % difference between years and dimensions.

I can easily do % of total, but I can't figure out the other table calcs.

 2015 2015 2016 2016 2017 2017 Category Something is < 80% Something is >= 80% Something is < 80% Something is >= 80% Something is < 80% Something is >= 80% Category 1 % of total 68% 32% 64% 36% 62% 38% actual difference on previous year 303 378 1053 799 % difference on previous year -4% 4% -2% 2%
• ###### 1. Re: Multiple Table Calculations - differences between dimensions and years

Hello Dave,

Would you have a sample workbook to review?  I ask because data in Microsoft excel often needs to be pivoted when bringing into Tableau to make sense and more easily work with it.

You might start with FAQ:  To Date Calculations  as a starting place for these sorts of questions as this FAQ contains many examples of the types of to-date and m over moth, year over year, month to date, etc.. type calculations.

Packaged workbooks: when, why, how

I hope this helps

Patrick