
1. Re: Calculations Using Table Values
Chris Geatch Dec 14, 2016 6:01 AM (in response to Daniel Price)1 of 1 people found this helpfulWithout having your data in Tableau to play with, this may not be quite right, but should give you a start. If you can post an example file, it will make it easier. Sorry about the dimension names, but hopefully you can work them out quite easily from the other parts of the formulae.
To get the 482,861 value for the first part of you calculation, you could use:
{EXCLUDE [ROW DIMENSION OF 0,1,2,3...]:SUM(IF [ROW DIMENSION OF ORIG BAL] = "Orig Bal" Then [MEASURE 1] ELSE 0 END)}
This one only adds up the values from the Orig Balance, without you having to have DIMENSION OF ORIG BAL 1 in your table. It also ignores the dimension on your rows, so you should get the same value for every row. The value will be broken down for each year displayed.
To get the 0.13% from your second table, you could use:
{EXCLUDE [YEAR]: AVG([PERCENTAGE FIELD])}
This one calculates the average ignoring the year field, so should give you the same value as your grand total column. Bear in mind, though, that if you filter your years, the average will be taken over the filter, not the entire dataset (which is also possible, if you want).
You can then either multiply those fields together, or put it all into one calculated field.

2. Re: Calculations Using Table Values
Daniel Price Dec 14, 2016 12:28 PM (in response to Chris Geatch)Thank you Chris! There were a couple of twists and turns but this set me on the right track for what I needed.
One challenge was that I needed the calculation only to run for years that have yet to occur (27 for 2014, 17 for 2015, 07 for 2016), so I had to add a table calculation to get that working. I got it working. Now I just have to figure out the totals! Sounds like this is a common issue, so I'm reading some of the Grand Total walkthroughs now . Thanks again.