Problem with pivot table in the expression above

geogou1973 — Tue, 06 Jul 2021 13:02:42 GMT

Hello i have a problem with the following expression in the pivot table.

When i expand to the field ITEM the following expression does not work

SUM({$<CATEGORY_MOVEMENT={'INV'}>} QTY_MOVES) - ABOVE(SUM({$<CATEGORY_MOVEMENT={'INV'}>} QTY_MOVES))

When i collapse into STORE and DATE works

In the expression INVENTORY QTY i have the expression SUM({$<CATEGORY_MOVEMENT={'INV'}>} QTY_MOVES)

Can anyone help me with this issue ?

Thank you in advance.

Re: Problem with pivot table in the expression above

geogou1973 — Tue, 06 Jul 2021 14:25:05 GMT

I found the solution.

I have to write the following expression

SUM({$<CATEGORY_MOVEMENT={'INV'}>} QTY_MOVES) - ABOVE(TOTAL SUM({$<CATEGORY_MOVEMENT={'INV'}>} QTY_MOVES))