Metrics in rows and columns

A report cannot contain metrics in both the rows and the columns, but you can simulate this scenario using view filters on multiple Grid/Graphs in a single document. The document shown below uses the Customer Count and Order Count metrics on the rows, while the Current and Last Month columns calculate the counts for the current month and the previous month. View filters on the Grid/Graphs filter for the Books category in the first set of data and Electronics in the second set.

The datasets for this document are shown below. The metrics are on the rows and the Category attribute is on the column. The data of the first dataset is in bold font while that of the second dataset is italicized to help you distinguish the source of the data when it is combined in the document.

Create a document with the two datasets and combine their data with text fields, as shown in the following diagram, which is a representation of the actual document. The data in bold font is from the first dataset, italicized data is from the second dataset, and plain text is static text fields created on the document. The boxes represent the different view filters applied to the data.