Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)