I would like to realize the subtotal by companies and profit center.
The subtotal is wrong , for example company B , the subtotal is 200*1.2=240 instead of 110+110 = 220 see bpc example
In order to calculation for TOTAL, we used the function 'Sorting and grouping (see bpc-function-sorting-and-grouping-with-subtotal.png and for the colummn Sales N, % increase and Sales N+1 , we used the default formatting sheet (see bpc-format.png)
BPC dont used the function subtotal 'sorting and grouping but the formula of format sheet and its incorret in order to calculation TOTAL
question : what is the solution in order to calculate 220 and not 240 for the company B
NB : its is a dynamic report
Please prepare your question in a readable form!
1. Text with correct line breaks.
2. Pictures added using "Insert Image"
I would like to realize the subtotal by companies and profit center.
The subtotal is wrong , for example company B , the subtotal is 200*1.2=240 instead of 110+110 = 220
In order to calculation for TOTAL, we used the function 'Sorting and grouping
BPC dont used the function subtotal 'sorting and grouping but the formula of format sheet and its incorret in order to calculation TOTAL
question : what is the solution in order to calculate 220 and not 240 for the company B
NB : its is a dynamic report
Add comment