4 Replies Latest reply: Aug 27, 2014 9:02 AM by sujeet singh RSS

    Calculated dimension with Set analysis?

    Dafnis X

      Hi All,

       

      I have a table with different types of transactions of a financial document.

      Each transaction has a key with the date of the first transaction and the document ID.

      So when the user selects a certain date, all the transactions are linked by that key.

      But, I would like to create a table where this key is ignored, and all the transactions are displayed according to their transaction dates. The  dimension is the document number.

      My question is, how to create the calculated dimension, and  ignore the key in that table.

       

        Thanks!