Adjust custom expression so that grand total displays correct value
I am using custom expression in cross table:
SUM([Sales target USD per Industry] / Count() over (Intersect([Industry],[Country]))) / 1000 as [Sales Target FY]
It displays correct values for single rows, but not for Grand total.
How to adjust this expression so that grand total repsesents the sum?