Problem with pivot table in the expression above

[geogou1973]

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.

[geogou1973]

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))