Typically, filtering report results will filter all results. This can be problematic for higher-level aggregates, which you may want to retain full values for. It is possible to apply some filters on the specific group members being displayed, allowing higher-level aggregates to remain intact. Group members can be filtered by ID, ORDER_NUM, and NAME.
{|CROSSTAB|}...
{|LOOP|CROSSTAB.YEAR(SORT=ORDER_NUM)}
<tr>
<th>{YEAR.NAME}</th>
#only display MONTH_OF_YEAR members that have an ORDER_NUM greater than or equal to 60
{|LOOP|YEAR.MONTH_OF_YEAR(SORT=ORDER_NUM,FILTER=ORDER_NUM|gte|60)}
<td>{COUNT(MONTH_OF_YEAR)}</td>
{/|LOOP|}
</tr>
{/|LOOP|}
</tbody>
</table>
</div>{/|CROSSTAB|}
{|CROSSTAB|}
...
#only display LOCATION_GROUPS with an ID of 1000023 or 1000024
{|LOOP|CROSSTAB.LOCATION_GROUPS(SORT=NAME,FILTERSET=ID|eq|1000023;ID|eq|1000024|OR)}
<tr>
<th>{LOCATION_GROUPS.NAME}</th>
#only display REGIONS with a NAME like "East"
{|LOOP|LOCATION_GROUPS.REGIONS(SORT=ORDER_NUM,FILTER=NAME|like|East)}
<td>{COUNT(REGIONS)}</td>
{/|LOOP|}
</tr>
{/|LOOP|}
...
{/|CROSSTAB|
There is currently no direct way to apply this kind of filter via a drop-down selector. However, it is possible to achieve member ID filtering via a drop-down via the following method:
#indicate that all filters other than the date filter should be ignored{|RESULT|KEEP_ONLY_FILTERS=TRENDING_TIMESTAMP}
#loop LOCATIONS, filtering the ID by the ID choosen in the LOCATIONS_SELECTOR
{|LOOP|RESULT.LOCATIONS(LIMIT=10,FILTER=ID|eq||EVALTAG(DATATYPES.SHOW_DATATYPE.LOCATIONS_SELECTOR.ID)|)}
{LOCATIONS.NAME}: {AVG(LOCATIONS.PERCENT_SCORE).ROUND()}<br />
{/|LOOP|}
{/|RESULT|}