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