Skip to main content
Topics#Tableau Desktop & Web AuthoringTableau Community Forums Member (Inactive)'s Question
Tableau Community Forums Member (Inactive) (Salesforce) asked in #Tableau Desktop & Web Authoring
Nov 30, 2018, 7:56 PM

Grand Total Issue

Hi

 

Here is my Requirement I have to display Grand Total row but with this requirement

 

Grand Total Issue

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

3 answers
  1. naman shah (Envision)
    Dec 12, 2018, 5:17 PM

    If I have something like this then your equation is not working

     

    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

     

    Equation i wrote for % to MTD

     

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

     

    Please guide me

Write an answer...
0/9000