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:

      http://img.photobucket.com/albums/v22/Alex_Chrono/Databases/IntermediaryTableIssue_zpsc7934560.png

       

      Here are the tables:

      http://img.photobucket.com/albums/v22/Alex_Chrono/Databases/IntermediaryTableDef_zps2f476aa9.png

       

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

       

      http://img.photobucket.com/albums/v22/Alex_Chrono/Databases/IntermediaryTableResult_zps5fd1934a.png

       

      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!