How to use calculated total on an advanced function?
Hi, I am wanting to have a total for the column % compliant. The field is calculated by using the advanced function and division of columns No. compliant SKUs / No. Core Range SKUs.
I have selected to use 'Calculated Total' however this leaves the total blank.
I believe my question is very similar to what was discussed in this forum here http://www.yellowfinbi.com/YFForum-How-to-get-the-Calculated-Total-in-Report-Output-?thread=170412
However, the answer suggested here states to use an append and sub query but as my report is a drill anywhere report this is not a suitable solution.