How to add calculations to a narrative in a report
I need to add almost like a header to a report with something like this:
Region: <this comes from a prompt filter I am adding>
FY YTD Points Won: <this number needs to be the sum of all values in Column 5>
% of Target: <this number needs to be the percentage of Points Won (sum of all values in Column 5) vs Target Points (which is a fixed value I have)
I now how to add the column itself to the narrative using the @ but that just shows all values one after the other one.
Your help is greatly appreciated it!
Cristina