1 2 Previous Next 22 Replies Latest reply on Sep 13, 2017 3:56 AM by Anitha p

    How to remove part of a label from the combined field

    Anitha p

      Hello Experts,

       

      I have a Pareto chart where I'm combining two fields (Region and Product Name) and Sales as my measure. Now the problem is in my X-axis, the Region name repeats itself on every dimension. Is there any way I can hide it from appearing from the labels. My Report users don't want to see these names getting repeated. Attached a sample workbook from Superstore data.

      As in the image attached you can see the region along with the product name like - Central , Bretford CR8500 Series Room meeting Furniture. From this I want to hide the Region name  -'Central' is this possible. Also I am not able to use the combined field in any calculations.

        1 2 Previous Next