Hello,
I Would like te create a table like this:
| KPI | Current year | Last year | Grow% |
|---|
| Total sales amount | € 120.000 | € 100.0000 | 20% |
| Toy sales amount | €40.000 | € 50.000 | -5% |
| Number of customers | 5.000 | 4.000 | 25% |
| Number of sales/products per customer | 24 | 25 | -4% |
Therefore I created a pivot table.
As dimenzion I defined
= valuelist
( 'Total sales amount','Toy sales amount', 'number of customers', 'number of sales per customer').
That works.
But how do I define the expressions?
I think I can best define two expressions Current year an Last year each containing 4 expressions. But how do this?
Could you please help?
Thanks
