4 Replies Latest reply on Apr 20, 2017 10:32 AM by Deepak Rai

    Level metric - City, state and country level

    Dheeraj H

      In tableau, I have to show the sales percentage across all cities with the sales percentage of the state and country side by side.

       

      The report should have 3 columns - City, Sales percent (City), Sales percent(State level), Sales percent (Country level). The state level sales will be same for all cities that come under same state. Same applies to states.

       

      Sales percent = Units sold / Units delivered. This calculation should apply to city, state and country level metrics.

       

      How to achieve this ?