Content in Tableau Community Forums /profile-content.jspa?filterID=contentstatus[published]&targetUser=13772 Recent content in Tableau Community Forums en Fri, 15 Feb 2013 21:04:44 GMT Jive Engage 8.0.5.0 (http://jivesoftware.com/products/) 2013-02-15T21:04:44Z en Grand Total row with Sums and Averages https://community.tableau.com/thread/123644 <!-- [DocumentBodyStart:f2d3532b-96a8-4e00-8057-6cfd484e870c] --><div class="jive-rendered-content"><p>When challenged with needing a grand total row to have both summed and averaged values I accomplished such using a <em>Table Calculation</em>.&#160; Set the grand total to be sums then use the <em>Window_Avg</em> function of the summed values for the columns needing to be averages.&#160; The attached document explains the specifics.</p></div><!-- [DocumentBodyEnd:f2d3532b-96a8-4e00-8057-6cfd484e870c] --> calculation average total sum Fri, 15 Feb 2013 21:04:44 GMT tableaucommunity@tableau.com https://community.tableau.com/thread/123644 2013-02-15T21:04:44Z 6 years 4 months ago 1 0