Pivot Table - Base 100 data

[Anonymous]

Hello.

I have a pivot table with 2 dimensions. First one is Date, second one is Product.
I would like to show the evolution of Products' Prices starting from 100 (rebased data).

Attached is the table that I would like to get. I have been trying to achieve this using First() function, but no luck...

Many thanks for your help.

[fosuzuki]

Hi,

Have you tried using set analysis?

Can you attach the QVW? At least for me, it is easier to help working on a sample QVW rather than talking conceptually.

Regards,

Fernando