Use the value of dimesion of pivot table

[Anonymous]

Hello,

how to use the value of on dimension of pivot table.

My table is like this

The dimension "Stock région" is num(aggr(sum({$<ANNEE_MOIS_CA={$(vMaxPeriode)},ABR_MAGASIN=>} MONTANT_STOCK),RECH_GROUPE_FAMILLE,LIB_PERIODE),'# ##0')

And i want to use this value in the pivot table to do for exemple 84 927 / 753 138.

How i can do this ?

Sophie

[simospa]

Hi Sophie,

did you try to create a variable containing your expression and use it?

S.

[Anonymous]

Hi Simone,

yes it's not possible to do this because ABR_MAGASIN= in the pivot table erase my selection and i don't want to do this.

Sophie