Rangesum in pivot table with multiple dimensions

[Vallentin]

Hello everyone,

I'm sorry for my english.

I have a pivot table with 4 dimensions :

ACTES_DATE_RECTRT = monthend(date)

ACTES_ENVIRONNEMENT

ACTES_MACSTD

ACTES_ACTSTD

And 2 expressions :

Stock by month : gave me the count of files in a month

Cumulative stock : count of files before the monthend

I want make a cumulative sum of "Stock" for each dimension before a monthend date.

Example with 2 dimension :

In my example, it's a green rows what a want.

I have use a function :

RangeSum(Below(Count({$<ACTES_STATUS={'EN_COURS'},ACTES_MEDIA_NEW-={'MAIL_GED','TELEPHONE'}>
+<ACTES_STATUS={'EN_COURS'},ACTES_ACTION_A_MENER={'OUI'}>}DISTINCT ACTES_ID_DOC),0,RowNo()),ACTES_DATE_RECTRT)

It's work just for dimension ACTES_DATE_RECTRT but when i expand my dimension ACTES_ENVIRONNEMENT, he gave me the same value of stock by month.

can anyone help me please? 

Thanks a lot.

[Taoufiq_Zarra]

Bonjour @Vallentin ,

can you share a complete sample !

est ce que tu peux partager un exemple de donnée ici directement dans le forum je ne peux pas ouvrir le fichier en PJ (bug in forum)