I was trying to get a dynamic pivot chart title, and wanted to show the amount on chart title as "This weeks Margin" & "£ " & "GetPivotData()". The problem is that the text appearing in the report shows multiple decimal places value when in pivot table it is not.

I would like the chart to display value as in pivot table like so:

PivotCell.png

The issue is the number formatting. You can see the formula bar as well as the chart title in the image. The GetPivotData() relies on value from grand total cell as in the previous image.

FormulaOptimise.png