This content has been marked as final.
Show 2 replies

1. Re: Customized Subtotals
Jamieson Christian Mar 1, 2017 2:57 PM (in response to efua biney)Efua,
Change your calculations to be simple aggregation calculations. At the row level, they will compute just for that row, but at the Subtotal and Grand Total level, they will compute over the entire aggregate set of data, which will yield what you want.
[ALOS]
SUM([Units Approved])/(SUM([Discharges])SUM([Net Denied]))
[Avg Days App Before Denial]
SUM([Partial App Days])/SUM([Partial Approved])
[Readmit Rate]
SUM([Readmissions])/(SUM([Discharges])SUM([Net Denied]))
NOTE: You will need to drag these new calculations back onto the view to change them from SUM or AVG aggregations to AGG (which means "already aggregated"). You may also need to tweak the number format for each.
And then… voila!
I've attached a workbook, but it's in version 10.1.5, so you may not be able to open it (sorry).

Subtotal Test_JC10.1.5.twbx 21.2 KB


2. Re: Customized Subtotals
efua biney Mar 2, 2017 9:54 AM (in response to Jamieson Christian)Like a charm, it worked! So much to learn with Tableau
Thanks a lot Jamieson. You're the man!!!!