
1. Re: How to output the difference between two table calculations?
Simon Runc Jun 28, 2018 4:49 AM (in response to Ayub Keshtmand)hi Ayub,
Firstly thanks for such an excellently worded/structured question. Very clear what you wanted, the Tableau version number and an example workbook...the big 3
So yes we can do this. First thing we can do, and this is a handy little trick. You have used the "Quick Table Calc" to create the % of totals...and this is just a short cut to get Tableau to write the formulas for us (we could just write them ourselves). But we can just CRTL+Drag the field onto the Measures Pane and now it's a reusable calculation (we also get the option to rename it). I've attached a .GIF showing how (for some reason the forum isn't allowing me to embed this in the thread!)
Once we do this with your 2 formulas, we can just use them to create the difference calculation
[% of Sales Diff Total vs Exclude]
[% of Sales]

[% of Sales (Exclude)]
btw You can do exactly the same for your My Metric versions, for sheet 3
Hope that makes sense, and solves your issue, but let me know if not

matrix table test  SR.twbx 1.3 MB

Reuse Formula.gif 262.8 KB
