How do I calculate sales per capita? There are six sheets within my Tableau Data: Store Location Sheet - Store ID(Numeric), City Name(string), County(Location), State Code(string), State(Location), Type(String), Latitude, Longitude, Area Code, Population(Numeric), Household Income(Numeric), Median Income(Numeric), Land Area(Numeric), Water Area(Numeric), Time Zone(String). Categories Sheet - Category ID(Numeric), Category(string). Customers Sheet - Customer ID(Numeric), Customer Name(String) Regions Sheet - State Code(String), State(Location), Region(string). Sales Order Sheet - Order Number(string), Sales Channel(String), Warehouse Code(String), Order Date(Date), Ship Date(Date), Delivery Date(Date), Currency Code(string), Sales Team ID(Numeric), Customer ID(Numeric), Store ID(Numeric), Category ID(Numeric), Order Quantity(numeric), Discount Applied(numeric), Unit Price(numeric), Unit Cost(numeric) profit(calculated field), Profit Margin(calculated field), Sales per Capita(calculated field), Sales Revenue(calculated field)
