Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
can you upload an example app.
You could try to concat the authors - example in the attachment
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
Thank you very much. You all been very helpful. The issue was resolved by the Concat expression
Regards
Sofie
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!