5 Replies Latest reply: Jun 18, 2016 9:42 AM by Tyler Waterfall RSS

    Hide dublicate rows

      Hi,

       

      I have a pivot table with several dimensions. One dimension is ISBN number and one dimension is author name. On the row with author name it displays several authors if one book has several authors. On the expressions row it calculates how many times each ISBN number has been read. In the case of two authors it displayes that it has been read two times (on time per author) eventhough it should only display that it has been read one time since it´s the same ISBN number. If the ISBN number has been read 2 times it shows 4 times (2 per author) and so on. Does any one know how to hide this duplicate row? I.e. how to only show the first author in this case?

       

      Thanks!

       

      /Sofie