3 Replies Latest reply on Mar 13, 2013 5:06 PM by Jonathan Drummey

    Create Calcualted with Table Calculation and Parition Not in the View

    Carson Dallum

      I've got a data set with one record per line of health care claims.  I'm trying to create a chart that shows the distribution of costs by member total cost.  For instance, I want to create the following hypothetical member total cost categories as a calculated field:

      • $1 - $1,000
      • $1,001 - $5,000
      • $5,001 - $25,000
      • $25,000 +

       

      I would then place this calculated field in a view and aggregate claims dollars across all members into each member total cost category.  I first tried creating a calculated field that used the formula total(sum([allowed])) and set the partition using the member ID.  The problem I'm having is that I cannot find a way to keep the member ID as the partition without including it in the view.  Is there a way to do this within Tableau?

       

      Thanks!