Content in Tableau Community Forums

Content in Tableau Community Forums /profile-content.jspa?filterID=contentstatus[published]&targetUser=21742 Recent content in Tableau Community Forums en Thu, 11 Apr 2013 05:21:44 GMT Jive Engage 8.0.5.0 (http://jivesoftware.com/products/) 2013-04-11T05:21:44Z en Custom grand total https://community.tableau.com/thread/125133 <div class="jive-rendered-content"><table border="0" cellpadding="0" cellspacing="0" style="width: 429px;"><tbody><tr><td class="xl63" height="20" style="border:0px solid black;" width="133"> </td><td class="xl64" style="border:0px solid black;border-left: none;" width="60">Sales(%)</td><td align="right" class="xl65" style="border:0px solid black;border-left: none;" width="47">Jun-10</td><td align="right" class="xl65" style="border:0px solid black;border-left: none;" width="43">Jul-10</td><td align="right" class="xl65" style="border:0px solid black;border-left: none;" width="50">Aug-10</td><td align="right" class="xl65" style="border:0px solid black;border-left: none;" width="49">Sep-10</td><td align="right" class="xl65" style="border:0px solid black;border-left: none;" width="47">Oct-10</td></tr><tr><td class="xl63" height="20" style="border:0px solid black;border-top: none;">Dept1</td><td align="right" class="xl63" style="border:0px solid black;border-left: none;border-top: none;">80</td><td align="right" class="xl63" style="border:0px solid black;border-left: none;border-top: none;">16</td><td align="right" class="xl63" style="border:0px solid black;border-left: none;border-top: none;">25</td><td align="right" class="xl63" style="border:0px solid black;border-left: none;border-top: none;">45</td><td align="right" class="xl63" style="border:0px solid black;border-left: none;border-top: none;">334</td><td align="right" class="xl63" style="border:0px solid black;border-left: none;border-top: none;">222</td></tr><tr><td class="xl63" height="20" style="border:0px solid black;border-top: none;">Dept2</td><td align="right" class="xl63" style="border:0px solid black;border-left: none;border-top: none;">100</td><td align="right" class="xl63" style="border:0px solid black;border-left: none;border-top: none;">90</td><td align="right" class="xl63" style="border:0px solid black;border-left: none;border-top: none;">92</td><td align="right" class="xl63" style="border:0px solid black;border-left: none;border-top: none;">99</td><td align="right" class="xl63" style="border:0px solid black;border-left: none;border-top: none;">1000</td><td align="right" class="xl63" style="border:0px solid black;border-left: none;border-top: none;">800</td></tr><tr><td class="xl63" height="20" style="border:0px solid black;border-top: none;">Dept3</td><td align="right" class="xl63" style="border:0px solid black;border-left: none;border-top: none;">30</td><td align="right" class="xl63" style="border:0px solid black;border-left: none;border-top: none;">23</td><td align="right" class="xl63" style="border:0px solid black;border-left: none;border-top: none;">11</td><td align="right" class="xl63" style="border:0px solid black;border-left: none;border-top: none;">10</td><td align="right" class="xl63" style="border:0px solid black;border-left: none;border-top: none;">7</td><td align="right" class="xl63" style="border:0px solid black;border-left: none;border-top: none;">20</td></tr><tr><td class="xl63" height="20" style="border:0px solid black;border-top: none;">Dept3</td><td align="right" class="xl63" style="border:0px solid black;border-left: none;border-top: none;">40</td><td align="right" class="xl63" style="border:0px solid black;border-left: none;border-top: none;">14</td><td align="right" class="xl63" style="border:0px solid black;border-left: none;border-top: none;">12</td><td align="right" class="xl63" style="border:0px solid black;border-left: none;border-top: none;">11</td><td align="right" class="xl63" style="border:0px solid black;border-left: none;border-top: none;">10</td><td align="right" class="xl63" style="border:0px solid black;border-left: none;border-top: none;">32</td></tr><tr><td class="xl66" height="20" style="border:0px solid black;border-top: none;">Grand Total</td><td class="xl66" style="border:0px solid black;border-left: none;border-top: none;"> </td><td align="right" class="xl66" style="border:0px solid black;border-left: none;border-top: none;">143</td><td align="right" class="xl66" style="border:0px solid black;border-left: none;border-top: none;">140</td><td align="right" class="xl66" style="border:0px solid black;border-left: none;border-top: none;">165</td><td align="right" class="xl66" style="border:0px solid black;border-left: none;border-top: none;">1351</td><td align="right" class="xl66" style="border:0px solid black;border-left: none;border-top: none;">1074</td></tr><tr><td class="xl66" height="20" style="border:0px solid black;border-top: none;">HighSale(>80%)</td><td class="xl66" style="border:0px solid black;border-left: none;border-top: none;"> </td><td align="right" class="xl66" style="border:0px solid black;border-left: none;border-top: none;">16</td><td align="right" class="xl66" style="border:0px solid black;border-left: none;border-top: none;">25</td><td align="right" class="xl66" style="border:0px solid black;border-left: none;border-top: none;">45</td><td align="right" class="xl66" style="border:0px solid black;border-left: none;border-top: none;">334</td><td align="right" class="xl66" style="border:0px solid black;border-left: none;border-top: none;">222</td></tr><tr><td class="xl66" height="20" style="border:0px solid black;border-top: none;">MidSale(>50%<80%)</td><td class="xl66" style="border:0px solid black;border-left: none;border-top: none;"> </td><td align="right" class="xl66" style="border:0px solid black;border-left: none;border-top: none;">16</td><td align="right" class="xl66" style="border:0px solid black;border-left: none;border-top: none;">25</td><td align="right" class="xl66" style="border:0px solid black;border-left: none;border-top: none;">45</td><td align="right" class="xl66" style="border:0px solid black;border-left: none;border-top: none;">334</td><td align="right" class="xl66" style="border:0px solid black;border-left: none;border-top: none;">222</td></tr><tr><td class="xl66" height="20" style="border:0px solid black;border-top: none;">LowSale(<50%)</td><td class="xl66" style="border:0px solid black;border-left: none;border-top: none;"> </td><td align="right" class="xl66" style="border:0px solid black;border-left: none;border-top: none;">37</td><td align="right" class="xl66" style="border:0px solid black;border-left: none;border-top: none;">23</td><td align="right" class="xl66" style="border:0px solid black;border-left: none;border-top: none;">21</td><td align="right" class="xl66" style="border:0px solid black;border-left: none;border-top: none;">17</td><td align="right" class="xl66" style="border:0px solid black;border-left: none;border-top: none;">52</td></tr></tbody></table><p style="min-height: 8pt; padding: 0px;"> </p><p>We required 4 rows for grand total for a report </p><p>1.Grand Total (over all)</p><p>2.Grand Total Sales for Greater than 80%</p><p>3.Grand Total Sales between 50 to 80%</p><p>4.Grand Total Sales less than 50%</p></div> Thu, 11 Apr 2013 05:21:44 GMT tableaucommunity@tableau.com https://community.tableau.com/thread/125133 2013-04-11T05:21:44Z 6 years 3 months ago 2 0