Forum Discussion

sheap069's avatar
sheap069
Icon for Helper III rankHelper III
6 years ago
Solved

Group Columns Based on Category and Make Table

Hello,   I have data in the following format:    And would like to create a table in my report in the following format:     Category 1 Category 2 Count 1 100 80 Count 2 50 ...
  • vanessafvg's avatar
    vanessafvg
    6 years ago

    Hello

    see attached. All this is done in the energy consultation.

    1. Take off the data

    2. Then divide the columns.

    obviously % sign will not apply when you have counts to the same extent, because you cannot mix data types to the same extent.