11 Replies Latest reply on May 24, 2013 8:56 AM by Joe Mako

    How to Structure Data for What If Analysis

    Ralph Lindenfeld



      I've attached an Excel workbook that shows roughly what I'm trying to accomplish in Tableau.


      As you can see, the values for Green and Red are calcuated from the prior period's total, based on a rate, and an additional factor.


      Additionally, I would like to break Green and Red into additional subcategories.


      I've found that if I don't start with the right structure, I end up painting myself into a corner.


      Any help would be appreciated.