I have the following table:
| CustomerGroup |
Type |
Amount |
| 10 |
B2B |
10.00 |
| 10 |
B2C |
20.00 |
| 20 |
B2B |
100.00 |
| 20 |
B2B |
200.00 |
I need to create a SSRS Report which contains consolidated data of the above
| Count |
Customer Group |
Type |
Amount |
| 1 |
10 |
B2B |
10.00 |
| 1 |
10 |
B2C |
20.00 |
| 2 |
20 |
B2B |
300.00 |
I created a report where I "GROUPED BY" first by Customer Group and then by "Type".
1. How do I get the count within a group. I used CountRows(CustomerGroup) but this does not count within the group. Can you please advise on what the expression should be so as to get the count within a group.
2. How to get total amount inside the group. I read that using "ADD TOTALS" will add a separate row outside the group having the total amount. But I do not a separate row. I need the total in the same row. Can you help me with the same?
Many thanks in advance.
