topic Re: Accumuated values in pivot table in App Development

Accumuated values in pivot table

Gestion-PSD — Wed, 14 Oct 2020 13:56:19 GMT

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.

Re: Accumuated values in pivot table

sunny_talwar — Thu, 15 Oct 2020 13:31:58 GMT

@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

Re: Accumuated values in pivot table

Gestion-PSD — Thu, 15 Oct 2020 14:42:49 GMT

Thanks, Sunny.

It's work prefectly.

Regards,

Alonso Torres.