Different expressions in a pivot table expression??

Thu, 21 Mar 2013 12:29:09 GMT

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

topic Different expressions in a pivot table expression?? in QlikView