Pivot table + complexe aggr expression

Fri, 05 Jun 2015 11:51:42 GMT

Hello,

I'm stuck on an expression since a while…

I would like a table resuming: New customers invoiced and lost customers

New customer invoiced = customers invoiced for the first time during the year, for a product's family or for a "under product family"

Lost Client = Client invoiced past year but not the next year, per family under product family.

I can get the expected results using a pivot table and hard coded expressions with values of the Years.

But this is not at all practical ... very heavy in terms of expression and not really optimized...

I would get the same thing but with years in dimension (to obtain real dynamic calculations…)

I have added an example of QVW with:
- A table that works but very inconvenient
- A second table that doesn't work… ( with years in dimension)

Thank you in advance !

topic Pivot table + complexe aggr expression in Francophones

Pivot table + complexe aggr expression