Forum Discussion
sheap069
Helper III
6 years agoGroup 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 ...
- 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.
vanessafvg
Community Champion
6 years agoHello
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.
sheap069
Helper III
6 years ago- vanessafvg6 years ago
Community Champion
hi you accepted the solution then you changed your mind, would appreciate if you could remark it as the solution or provide thte solution.