Hi there.
I am having a problem filling columns conditionally in a straight table.
I tried to create a expression that works fine but without luck.
I want to have a value cluster per client. The client can have several products and depending on any combination of filter criteria the sum of the value should be displayed in one of the value clusters.
e.g.
1. Selecting all clients the sum per client should be displayed in the dedicated value cluster.
2. Selecting only one client. Values should be split in the value cluster depended of the sum per product.
I tried to give a simple example below
| CLIENT | PRODUCT | VALUE |
| 12345 | A | 100 |
| 56879 | A | 20 |
| 12345 | B | 50 |
| | |
| | |
| Sum of all clients |
| CLIENT | VALUE |
| >=20 <=50 | >=50 <=200 |
| 12345 | 0 | 150 |
| 56879 | 20 | 0 |
| | |
| Selecting Client 12345 |
| CLIENT | VALUE |
| >=20 <=50 | >=50 <=200 |
| 12345 | 50 | 100 |
Thanks
