Hello,
I need help in a pivot table when i want to create groups from an expression.
I have a list of clients with the sales of two years:
Client SaleYear1 SaleYear2 Evolution
| Gran Khors S.A. | 12 | 40 | 233% |
| Frescar S.A. | 176 | 584 | 232% |
| Crosetti German Marcelo | 15 | 42 | 180% |
| Rabellini Butori Carlos I. | 20 | 14 | -30% |
| Parque Srl | 33 | 23 | -30% |
I want to creat a group with all de clients that have negative evolution (4 y 5) and other group with the one who has positive evolution (1,2,3)
I tried creating a Dimension with the following expression:if((saleyear 1 – Saleyear2)<0, Group1,Group2) but it does not work
Thanks
