
1. Re: Sum results from multiple dimensions
sunil.sachdeva Oct 3, 2017 1:23 AM (in response to Brigitte C)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
Catherine Brown Oct 3, 2017 6:32 AM (in response to Brigitte C)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 AdHoc Calculations in Tableau 9 – VizPainter
Catherine

Example.twbx 13.2 KB


3. Re: Sum results from multiple dimensions
Brigitte C Oct 4, 2017 6:08 PM (in response to sunil.sachdeva)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
Brigitte C Oct 4, 2017 6:08 PM (in response to Catherine Brown)Thanks Catherine, this has answered my question! Thanks for the details on packaged workbooks as well.