For reports on service catalog data, you can stack and group data by variables, use variables as columns in list reports, and use variables as columns and rows in multilevel pivot tables.

About this task

For primary Group by and Stack by these steps are intuitive.

Note: List, Box, Trendbox, and Pivot reports cannot use service catalog variables as a primary or secondary Group by. Single Score, Calendar, Control, and Map reports do not support Group by on any fields. List reports can use service catalog variables as columns.

Follow these steps below to use a variable as an additional Group by, as a column in a list report, or as a column or row in a multilevel pivot table.

1. Navigate to Reports > View / Create and open the report to add the variable to.
2. Do one of the following:

   Option	Description
   Add as a column in a list report	On the Configure tab, select Variables+ at the bottom of the Available slushbucket.
   Add as an additional Group by	On the Configure tab, click Additional group by, then select Variables+ at the bottom of the Available column in the Additional group by slushbucket.
   As as a column or row in a multilevel pivot table	Click Select columns or Select rows, then select Variables+ at the bottom of the slushbucket that appears.

3. Click the structure icon () the plus sign that appears.
   A list of service catalog items appears.
4. Select a catalog item where the variable has been added.
   The variables for that item appear in the Available slushbucket.
5. Move the variable that you want to use to the Selected column.
6. Save the report.