It achieved my desired output for the taxable amount and taxes. However the main issue arises when I expressed the subtotal in a Pivot Table. I do not wish to include values that are 0 in the calculation of the subtotal.
Can anyone advise me on how to achieve the desired output expressed in pivot table?
thank you all for the help here. Unfortunately it did not solve my issue .
My guess is perhaps my questions was poorly formatted resulting in the confusion.
I am only interested in calculating the subtotal using the value calculated in my GP and Taxes's expressions. I have tried aggre() and dimensionality() but it appears those solutions are not exactly what I am looking for.
The main reasons is because Qlikview take into considerations of my calculated negative gross profit value instead of using 0 as stated in my GP expressions