1 of 1 people found this helpful
The reason why you are being forced to use ATTR or ZN is because in Tableau, data blend happens after the data is aggregated. Tableau first aggregates the data and then blends it. Using WINDOW_SUM() or TOTAL() for grand totals should solve your issue, totals will come from different sheet and you can place that sheet on a dashboard in floating order just below your actual view.
Thanks for your prompt reply. I realized the fact that Blending wont work on aggregated data. As an alternate, I replicated same data from same SQL source. I would like to learn more about WINDOW_SUM function here, but for now, I'm just using the basic approach.