5 Replies Latest reply on Aug 17, 2016 12:30 PM by Amber Zimmermann

    Creating a Calculated Field with a Dimension

    Amber Zimmermann


      I've just spent more time that I care to admit reading and searching for how to create a basic market share calculation (rev/market size), yet even with all the examples on calculating dimensions, I can't seem to make it work. The attached image is what I am hoping for - an overlying line that shows market share.


      I am fairly new to tableau and I know this is wrong, but this is what am I wanting to do:  sum ([type] = 'Revenue')/ sum([type] = "Market size'


      Attached is the workbook from my screenshot.


      Thank you ever so much in advance!