4 Replies Latest reply on Oct 4, 2017 6:08 PM by Brigitte C

# Sum results from multiple dimensions

Hello,

New to Tableau and I have tried to create calculations to solve this but I think I may have overcomplicated things.  Is there a simple way to do this?

I have three fields that have the same response values (Yes, No, NA or Null).  I want to count all of the response values across the three dimensions for an overall total value.  For example, if I have 17 "yes" responses in the "Check 1" Dimension, 3 in the "Check 2" and 1 in the "Check 3" I want a "Total Check" field to show as Yes = 21.

I have created a basic example workbook here with the three fields.

Thanks for any help!

Brigitte

• ###### 1. Re: Sum results from multiple dimensions

could you please attach packaged workbook (.twbx) file to explore your scenario with data?

or attach sample .csv or .xls file.

thanks

• ###### 2. Re: Sum results from multiple dimensions

In the future others will find it helpful if you use a packaged workbook, rather than a regular workbook.  The package workbook will include the data used in the workbook.  Otherwise, when we open a regular workbook we receive an error.

Packaged workbooks: when, why, how

Even without that I think I understand your issue.  I don't think you are over complicating it.  For me, it is easiest to work through the calculation step wise.  There are some short cuts you will learn and you use the product, as well.

Step 1 - Create a calculation for each 'Check' dimension that counts or sums the instances of 'Yes'. You'll end up with 3 calculations.

Step 2 - Create a calculation which adds these 3 calculations together.

You can wrap them all into one calculation, if you like.  Or you can drag and drop the measures into the measure value shelf and write the calculation there.

I've attached a packaged workbook with a sample.

Also, here is an article about writing ad hoc calculations in the measure values shelf. 10 Things you didn’t know about Ad-Hoc Calculations in Tableau 9 – VizPainter

Catherine

1 of 1 people found this helpful
• ###### 3. Re: Sum results from multiple dimensions

Thanks Sunil, I thought I did that but I didn't realise it had to be a packaged workbook! I will do that for my future posts.

• ###### 4. Re: Sum results from multiple dimensions

Thanks Catherine, this has answered my question! Thanks for the details on packaged workbooks as well.