4 Replies Latest reply on Jul 1, 2015 9:30 AM by Luis de la Torre

    Custom Geographic Regions and Calculating Percentages By Region

    Luis de la Torre

      There many questions defining custom regions and doing calculations over them.


      This question: Data at Area level (different than the provinces level) has a great answer in the form of a workbook that calculates the sum of sales by geographic region.


      My question is: rather than calculating and displaying the sum of sales by custom geographic region, how can I calculate and display the percentage of sales by custom geographic region?


      As a shot in the dark, I tried changing SUM([Sales]) in LOD Region or State to SUM([Sales]) / TOTAL(SUM([Sales])), but I get the error "Level of detail expressions cannot contain table calculations or the ATTR function."


      I am using Tableau 9.0.2.