Adjust custom expression so that grand total displays correct value

Hi!

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?

 

Attachments

AttachmentSize
Image icon capture.png4.05 KB

(1) Answer

Login