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
Jul 2, 2013, 11:50 AM

Table calculation

Hi all,

 

please see below my issue :

 

Table calculation

 

I wan't to calculate in the last field, for the firt line for example : 12/211

Even if i filter on an ORGANISATION, i would like to keep the 211 sum.

 

I tried to use the window_sum and other...

 

Thanks a lat for your help !

 

Steven

1 answer
  1. Tableau Community Forums Member (Inactive) (Salesforce)
    Jul 2, 2013, 12:16 PM

    Steven,

     

    You have to alter the way you filter.  Instead of filtering on Organization, filter on

     

    LOOKUP( ATTR( [Organization] ), 0 )

     

    This technique is explained in more detail at

     

    Breaking BI: Creating Table Calculations on Values outside of the Filter Range in Tableau

     

    Thanks,

     

    Brad Llewellyn

    Associate Consultant

    Mariner, LLC

    brad.llewellyn@mariner-usa.com

    http://www.linkedin.com/in/bradllewellyn

    http://breaking-bi.blogspot.com

Write an answer...
0/9000