Accumuated values in pivot table

[Gestion-PSD]

Hi all!

I'm in a trouble with a expression than I don't know if it's possible to create.

I have a 3 rows (dimension) levels pivot table: Client -> YearMonth->Agent.

I want an expression than accumulate the measure sum(minutes) yearmonth to yearmonth for each agent. I tink if I swap YearMonth <-> Agent, an expression like

rangesum(above(round(Sum(duracion)/60),0,rowno()))

would run, but I need the dimensions as they are: 1st Client, 2nd YearMonth 3rd Agent.

Could someone help me?

Best regards,

Alonso Torres.

[sunny_talwar · Accepted solution]

@Gestion-PSD add Aggr() function to dictate sorting

Aggr(RangeSum(Above(Round(Sum(duracion)/60), 0, RowNo())), Client, Agent, YearMonth)

now even though your chart has Client, YearMonth, Agent as the order of your dimension, the expression will see it as Client, Agent, YearMonth and display the results accordingly

[Gestion-PSD]

Thanks, Sunny.

It's work prefectly.

Regards,

Alonso Torres.