6 Replies Latest reply on Apr 2, 2013 11:36 AM by Ashley Howard

    Need help... totals and intermediate tables

    Rommel Metrillo

      Hey guys,


      Need some help on this issue I have


      Consider the data below:



      Here are the tables:



      I want to be able to have them displayed in Tableau (table form), somewhat like this:




      The ACCT ID and Amount for "Bonnie" may or may not appear, what is important is the grand total only counts the amount for unique ACCT IDs (900) instead of all the records, currently when I do this in Tableau it shows "1000" (since it counts the amount for "Bonnie" as well).


      Thanks in advance!