Problems with subtotals in pivot table

Wed, 08 Feb 2017 15:41:56 GMT

Hello everyone. I need your kind help, please.

I would like to know if it is possible and what would be the solution for this type of problem:

I have a pivot table box that shows me the totals and subtotals by 'CENTROS' (CENTRO ORIGEN and CENTRO DESTINO); So far the result is correct.

However, when I want to filter rows that only paint the red '%', the result for totals and subtotals are not correct.

I would like to know, if the subtotals respect the conditionals that I put in the expression. What can the error be due to?

Re: Problems with subtotals in pivot table

marcus_sommer — Wed, 08 Feb 2017 16:14:59 GMT

I assume that you need an aggr-function around your expressions to get the correct totals. I mean something like this:

sum(aggr(YourExpression, Dim1, Dim2, ...))

- Marcus