10 Replies Latest reply on Sep 18, 2017 3:39 PM by Shinichiro Murakami

    How to list only one record if all rows remain same in a pane ?

    Michael Ye

      Please see the workbook attachment (V10.3). Please note that the region and ship mode are listed as labels with place holders (Dimension header have been hidden). The reason I do so is that I want to make the two dimensions colorful in different modes according to their values. My question is, how to list only one record if all rows remain same in a pane ? For example, in the Region field, I want to list only one "Central" other than four. So does East, South and West. I want to list them only once (just like the category dimension, only one "Furniture" is listed in all regions).

       

      Thanks,

       

      Michael