3 Replies Latest reply on Dec 12, 2018 9:17 AM by Naman shah

# Grand Total Issue

Hi

Here is my Requirement I have to display Grand Total row but with this requirement Sales, Goals and LY Sales are fine. But for % to LY  and % to Goal it is displaying total of of rows but I want

to display %to Goal total should be Grandtotal of Sales / Grand Total of Monthly Goals

same for  %to Ly  = Grand total of Sales / Grand total of LY

Is it possible ?

Thanks

Naman

• ###### 1. Re: Grand Total Issue

Naman,

You need to use LOD expressions.

Try: % to LY

SUM({FIXED [Month_of_]:SUM([Sales])}) / SUM({FIXED [Month_of_]:SUM([LY Sales])})

% to goal:

SUM({FIXED [Month_of_]:SUM([Sales])}) / SUM({FIXED [Month_of_]:SUM([Goals])})

[Month_of_] is the dimension you used. It is not complete here, since in your screenshot it only show this.

Hope it helps.

Michael Ye

1 of 1 people found this helpful
• ###### 2. Re: Grand Total Issue

Naman,

You should aggregate the Metrics and then apply the division for the grand total you're expecting.

So, if you have your % to LY  as [Sales]/[LY Sales], it sshould be SUM([Sales])/SUM([LY Sales])

and same thing with % to Goal it should be SUM([Sales])/SUM([Monthly Goals])

• ###### 3. Re: Grand Total Issue

If I have something like this then your equation is not working Equation i wrote for % to MTD

SUM({FIXED [U_Division]:SUM([MTD])})/SUM({FIXED [U_Division]:SUM([Monthly Goal])})

Please guide me