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
Apr 30, 2017, 8:01 PM

Grand Total for Unique Values

Hi,

I need one of the columns to give me the SUM of the values. When I use Grand Total function it gives me the unique count. Is there a way to change the calculation just for one filed?

 

Grand Total for Unique Values

3 answers
  1. Tableau Community Forums Member (Inactive) (Salesforce)
    May 1, 2017, 1:17 AM

    Hi, Vita

     

    I think you need a LOD calculation to achieve your Grand Total. See below example

    Hi, Vita I think you need a LOD calculation to achieve your Grand Total. See below example basically, the LOD helps to get the countd as daily base and then sum the count number of each day as total.

     

    basically, the LOD helps to get the countd as daily base and then sum the count number of each day as total.

     

    Hope this could help.

    ZZ

Write an answer...
0/9000