0 Replies Latest reply on Jan 20, 2019 8:25 PM by Clint Trocchio

    Display the Row, But Don't Add The Row

    Clint Trocchio

      I would like to display row values in a Tableau crosstab 'accounting ledger' and I'm having trouble with my aggregate calculations.  I'd like to show all rows of Group and Sub Group elements, but for a few Sub Group elements, I'd like to display the rows yet not include those rows' columnar values in aggregate (Total) calculations.

       

      For instance, in the attached Excel file and associated .twbx workbook, I would like to make row "Sub AA" visible in the crosstab but not additive in the total.  In this instance, I would like to make evident Sub AA's value - 50 - an "of which" value that is included in Sub A's value - 100.