Skip to content

group-data-by-columns-or-rows-in-a-mobile-report-reporting-services.md

Latest commit

 

History

History
61 lines (37 loc) · 4.11 KB

group-data-by-columns-or-rows-in-a-mobile-report-reporting-services.md

File metadata and controls

61 lines (37 loc) · 4.11 KB
title Group data by columns or rows in a mobile report | Reporting Services
description In Mobile Report Publisher, you can organize data by columns or by rows in many types of charts. This article illustrates data structured by columns or by rows.
ms.date 09/25/2024
ms.service reporting-services
ms.subservice mobile-reports
ms.topic how-to
ms.custom
updatefrequency5

Group data by columns or rows in a mobile report | Reporting Services

[!INCLUDE ssrs-mobile-report-deprecated]

You can organize data by columns or by rows in many types of charts in [!INCLUDESS_MobileReptPub_Short]. Follow along in this step-by-step article.

In time, totals, pie, and funnel charts, you can organize the data by rows or by columns.

  • Organizing by columns is useful if a table has several columns of data you'd like to compare.
  • Organizing by rows works better if one column in the table contains the names of the different categories.

The following steps use a comparison totals table with the simulated data in [!INCLUDESS_MobileReptPub_Short] to illustrate the difference between structuring the data by rows or by columns in a chart.

  1. Drag a Comparison totals chart from the Layout tab to the design surface and make it bigger.

  2. Select the Data tab. You see the SimulatedTable table contains a series of columns, Metric1 through Metric5 and Comparison1 through Comparison5.

    :::image type="content" source="../../reporting-services/mobile-reports/media/mobile-report-data-group-column.png" alt-text="Screenshot of mobile report data group columns.":::

  3. In the Data properties pane, Main Series is SimulatedTable. Select the arrow in the box next to Main Series, and you see Metric1 through Metric5 selected.

    :::image type="content" source="../../reporting-services/mobile-reports/media/mobile-report-properties-columns.png" alt-text="Screenshot of the options next to the Main Series.":::

    You see same for Comparison Series. Comparison1 through Comparison5 are selected.

  4. Select Preview.

    :::image type="content" source="../../reporting-services/mobile-reports/media/mobile-report-chart-by-columns.png" alt-text="Screenshot of the preview of the Comparisons Totals Chart.":::

    Each bar in the chart represents one column in the table. The thicker bars are the Metrics columns and the thinner bars are the Comparison columns.

  5. Select the back arrow in the upper-left corner to leave preview mode.

  6. On the Layout tab, in the Visual properties pane change Data structure from By columns to By rows.

  7. Select the Data tab. Now the SimulatedTable table has a Category column along with the Metric and Comparison columns, with Category A through E.

    :::image type="content" source="../../reporting-services/mobile-reports/media/mobile-report-data-group-rows.png" alt-text="Screenshot of mobile report data group rows.":::

  8. In the Data properties pane, there's now a Category Column box, which lists the Category column from SimulatedTable. In Main Series, you can pick which column to use for the values. By default, [!INCLUDESS_MobileReptPub_Short] selects Metric1 through Metric5 for the Main Series and Comparison1 through Comparison5 for the Comparison Series.

    :::image type="content" source="../../reporting-services/mobile-reports/media/mobile-report-properties-rows.png" alt-text="Screenshot of the options next to the Comparison Series.":::

  9. Select Preview.

    :::image type="content" source="../../reporting-services/mobile-reports/media/mobile-report-chart-by-rows.png" alt-text="Screenshot of the preview of the updated Comparisons Totals Chart.":::

    Now each bar in the chart represents the values for each category in the Category column.

Related content