Forum Discussion
Add Sum on column based on customer_id which cannot be used as a Group in Tablix
Hello, I have a requirement where i want to check the number of customer who have transaction amt greater then 0, As Customer is a detail row it cannot be used in the tablix as i just need the nu...
Hi Anonymous ,
Could you please provide desensitized example data and a screenshot of your desired results?
Thanks for your efforts & time in advance.
Best regards,
Community Support Team_ Binbin Yu
Hello Team,
I am currently getting below records when i use count distinct and check the records to be greater then 0
| Famillie product | Cnt customer with Positive transaction |
| A | 10 |
| B | 20 |
| C | 30 |
Now if you check the detail records for famille product A
| Familllie | CAnne | Customer_id |
| A | 10 | A11 |
| A | -9 | A11 |
| A | 10 | A12 |
| A | 15 | A12 |
| A | 10 | A13 |
| A | 16 | A13 |
| A | -33 | A13 |
| A | 10 | A14 |
| A | 20 | A15 |
| A | 30 | A15 |
| A | 40 | A16 |
| A | 20 | A17 |
| A | 10 | A17 |
| A | 10 | A18 |
| A | 70 | A19 |
| A | 80 | A19 |
| A | 90 | A19 |
| A | 100 | A19 |
| A | 10 | A20 |
I should only get the customer count as 9 for Famillie product A as for customer "A13" the sum of CAnne will be negative.
| Famillie product | CAnne | Customer_id | Material |
| A | 10 | A11 | MAT_A |
| A | -9 | A11 | MAT_B |
| A | 10 | A12 | MAT_A |
| A | 15 | A12 | MAT_B |
| A | 10 | A13 | MAT_A |
| A | 16 | A13 | MAT_B |
| A | -33 | A13 | MAT_C |
| A | 10 | A14 | MAT_A |
| A | 20 | A15 | MAT_B |
| A | 30 | A15 | MAT_C |
| A | 40 | A16 | MAT_A |
| A | 20 | A17 | MAT_B |
| A | 10 | A17 | MAT_C |
| A | 10 | A18 | MAT_A |
| A | 70 | A19 | MAT_B |
| A | 80 | A19 | MAT_C |
| A | 90 | A19 | MAT_D |
| A | 100 | A19 | MAT_E |
| A | 10 | A20 | MAT_F |
Can you please help!
REgards,
Arif