6 Replies Latest reply on May 9, 2016 7:26 AM by Łukasz Majewski

    Calculated field linked to FIlter selection??

    James Mclean

      Hello Everyone,

       

      Please can someone try and help me regarding calculations and filters?

       

      I am currently trying to show a specific manufacturer (out of a list of many) versus the total sales of the category in a specific region.

       

      I have used this calculation " If [Manufacturer]= "Mine" then [Value] else 0 end " and this does pull the manufacturer I would like and I can compare this to a filtered selection of all other manufacturers - but i would like the calculation to be dynamic.

       

      For example - if i chose a competitor manufacturer then i want to see total category sales compared to that specific competitor. With the above calculation however, when i chose a different manufacturer the chart goes blank.

       

      An additional problem with this view in tableau is that share calculations show the share in each region as cumulative to total market as opposed to showing what share my manufacturer has in that specific region.

       

      Below is an image to try and help explain.  Each purple bubble is my manufacturer, the orange bubble is the category.  I would like the purple bubble to change based on the manufacturer i select in the filter and the orange stays as total category.  Each set of purple and orange bubbles represents a region.  The share shown in the image however sums to 100% instead of representing the share the manufacturer holds in that region.  Fro example, the bottom left purple bubble is almost as large as the orange bubble but the share displayed is 48% when the share within that region is closer to 80%.

       

      I have also attached a raw data excel file.  Its the data behind the below image.

       

      Please can someone try to help me?

       

      Thank you.