3 Replies Latest reply on Sep 14, 2016 11:01 AM by Luciano Vasconcelos

    Maintaining "% Of" When Creating Map

    Taylor Haugarth

      Hello,

       

      Going crazy trying to figure this out! My goal is to make a map showing 'Brand A's' % of 'Brand A + B + C' for each individual state. Hopefully these images help show my problem...

       

      These are the total sales dollars for each brand by state.

      Capture.JPG

      To get the % of each brands sales by state I chose "Analysis" to "Percentage Of" and selected Column. This is what I want to map (best case I could just have one map and filter to each brand I want to see)

      Capture.JPG

      When I select map, it gives me 3 (not ideal but not the main issue).

      Capture.JPG

      Mapping switches the % of column calculation I selected to % of total. As you can see, 'Brand A' in South Carolina is now 0.116% & it should be 12.9% as that is Brand A's percent of sales in SC among all 3 brands.

      Capture.JPG