Hide dublicate rows

[#1]

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

[srchilukoori]

can you upload an example app.

[struniger]

You could try to concat the authors - example in the attachment

[Anonymous]

Sofie,

I recommend not to use Author names as dimension.  Use only one dimension, ISBN, and authors can be in expression like this

concat (distinct "Author Name", '; ')

Apparently there is no need for pivot table in this case, you can use straight.

Regards,

Michael

[#5]

Thank you very much. You all been very helpful. The issue was resolved by the Concat expression

Regards

Sofie

[Tyler_Waterfall]

sofie.zettergren‌ - found your post here and am curious how you were cataloging books. I'm interested in cataloguing our library but would love to find a source for ISBN and book information (instead of manually entering the info).

Thanks!