{DATATYPES.REPORT_CONFIG.SHOW_GROUP.INPUT}
Sometimes it’s preferable to allow your user to select which group they would like to break their report out by. For this, you use the SHOW_GROUP selector.
{|SHOWIF|OUTPUT_MODE=|EVALCONST(KNICKERS_OUTPUT_STANDARD)|}{DATATYPES.CONTROLS_START}{DATATYPES.DEFAULT_DATE_FILTERS}
<div>
<label>Display</label>
{DATATYPES.SHOW_DATATYPE.SHOW_GROUP.INPUT}
</div>
{DATATYPES.CONTROLS_END}{/|SHOWIF|}
#display the selected group crosstabbed against month-year
{|CROSSTAB|}
<table>
<thead>
<tr id="header-row">
<th>{DATATYPES.SHOW_DATATYPE.SHOW_GROUP.NAME}</th>
{|LOOP|CROSSTAB.SHOW_GROUP(SORT=NAME)}
{|SHOWIF|LOOP.ISFIRST}
{|LOOP|SHOW_GROUP.MONTH_YEAR(SORT=ORDER_NUM,CROSSTAB_FILTER=WITH_BLANKS_IN_RANGE)}
<th>{MONTH_YEAR.NAME}</th>
{/|LOOP|}
</tr>
</thead>
<tbody>
{/|SHOWIF|}
<tr>
<th>{SHOW_GROUP.NAME}</th>
{|LOOP|.MONTH_YEAR}
<td>{COUNT(MONTH_YEAR)}</td>
{/|LOOP|}
</tr>
{/|LOOP|}
</tbody>
</table>
{/|CROSSTAB|}