Skip to main content
Topics#Tableau Desktop & Web Authoringjagruthi mothukuri's Question
jagruthi mothukuri asked in #Tableau Desktop & Web Authoring
Jan 18, 2014, 12:09 AM

Grand Totals irrespestive of fields displayed in sheet

Hi,

 

I want to make the grand total fixed, irrespective of what fields are displayed on sheet.

 

Please find atttached workbook, in which I want to display the grand total of CSR count as 7 even when CSR name is note displayed.

Any help is appreciated.

 

Thanks in advance.

Grandtotals.twbx
8 answers
  1. Tableau Community Forums Member (Inactive) (Salesforce)
    Jan 20, 2014, 7:36 PM

    Thanks for pointing that out. I didn't see that. Understanding the scope of aggregates and controlling aggregation in Tableau  is hard.

     

    Attached is a further revision of the workbook.  Here's an image:

     

    Thanks for pointing that out. I didn't see that. Understanding the scope of aggregates and controlling aggregation in Tableau is hard. Attached is a further revision of the workbook.

     

    I removed the SUM() aggregate function in the csr count calculated field. I also changed the result from using the count() aggregate function to use just the integer value 1.  Then, to obtain the 7, I sum the csr count outside the calculated field.

     

    The scope of the aggregates change when they are not use in the calculated field.

     

    I think there are a couple of other solutions. This is just one. 

Write an answer...
0/9000