</ iframe > </noscript> <!-- End Google Tag Manager (noscript) --> <div id="BeforeHeaderContent"> </div> <div id="HeaderContent"> <div id="ProjectTitle"></div> <div id="PageTitle"><div id="PageTitleText">Specifying a Subtotal Function</div></div> </div> <div id="AfterHeaderContent"> <!-- Spacing --> <span id="ToggleAllSectionsLink" class="FunctionLink"> <label id="CollapseAllLabel">Collapse All</label> <label id="ExpandAllLabel" style="display: none;">Expand All</label> </span> </div> <div class="BreadcrumbsContainer"><table><tr><td> <a href="WelcmPg.html">Welcome to LightSwitch Desktop Edition</a> > <a href="ComponentOneOLAPforLightSwitchOverview.html">OLAP for LightSwitch Overview</a> > <a href="OLAPforLightSwitchTaskBasedHelp.html">OLAP for LightSwitch Task-Based Help</a> > Specifying a Subtotal Function</td></tr></table></div> <div id="BodyContent"> <p>When creating custom views of data, you may want to perform a different aggregate function other than "Sum" on your column or row. For example, you may want to find the average or maximum values in your data. This can easily be done through the <b>Field Settings</b> dialog box.</p> <h3>To Specify the function performed on data at runtime:</h3> <ol> <li>Right-click a field in the Values area of the C1OlapPanel.</li> <li>Click Field Settings in the context menu. The Field Settings dialog box opens.</li> <li>Click the Subtotals tab.</li> <li>Select one of the following options: <table style="BORDER-TOP-STYLE: hidden; BORDER-BOTTOM-STYLE: hidden; BORDER-RIGHT-STYLE: hidden; BORDER-LEFT-STYLE: hidden" cellspacing="0" cellpadding="0" border="0"> <tbody> <tr> <td valign="top" width="156"> <p><b>Sum</b></p> <p><b>Count</b></p> <p><b>Average</b></p> <p><b>Maximum</b></p> <p><b>Minimum</b></p> <p><b>First</b></p> <p><b>Last</b></p> <p><b>Variance</b></p> <p><b>Standard Deviation</b></p> <p><b>Variance Population</b></p> <p><b>Standard Deviation Population</b></p> </td> <td style="BORDER-TOP-STYLE: hidden; BORDER-BOTTOM-STYLE: hidden; BORDER-RIGHT-STYLE: hidden; BORDER-LEFT-STYLE: hidden" valign="top" width="387"> <p>Gets the sum of a group.</p> <p>Gets the number of values in a group.</p> <p>Gets the average of a group.</p> <p>Gets the maximum value in a group.</p> <p>Gets the minimum value in a group.</p> <p>Gets the first value in a group.</p> <p>Gets the last value in a group.</p> <p>Gets the sample variance of a group.</p> <p>Gets the sample standard deviation of a group.</p> <p>Gets the population variance of a group.</p> <p>Gets the population standard deviation of a group.</p> </td> </tr> </tbody> </table> </li> <li>Click <b>OK</b> to close the <b>Field Settings</b> dialog box. Notice how the values in the summary table change.</li> </ol> <a name="seealsobookmark"></a> </div> <div id="FooterContent"> <p> </p><p> </p><hr style="height: 1px"><p>Copyright (c) <script type="text/javascript"> var theDate=new Date() document.write(theDate.getFullYear()) </script> GrapeCity, inc. All rights reserved. <script> $(document).ready(function() { if (!(window.self !== window.top)) { // Not running in a frameset // Get the page name var pageName = location.href.substring(location.href.lastIndexOf("/") + 1); if (pageName.indexOf("#") != -1) { pageName = pageName.substring(0, pageName.indexOf("#")); } // Append to webframe.html var framePage = "webframe.html#" + pageName; location.href = framePage; } }); </script></p> <a href="http://our.componentone.com/groups/" target="_blank">Product Support Forum</a> | <a href="http://feedback.componentone.com/forums/255782-winforms-documentation" target="_blank">Documentation Feedback</a> </div> </body> </html>