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