Anyone? I would really like to know if there is a way to do this. Thanks!
The TOTAL() table calc is issued in the underlying data source and given the way blends are done in Tableau, this won't work. However, other table calcs like WINDOW_SUM() will happily work. If you are looking to do a TOTAL(SUM([a])/SUM([b]), though, you'd probably need to something like WINDOW_SUM(SUM([a]))/WINDOW_SUM(SUM([b]))