Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Kindly Provide Sample Data.... !
Hi,
I would like to show all the transactions regardless of the field key shop & date.
This key is linked to a selection in the sheet, and I would like to ignore it in the table I described above.
thanks!
Need base data in excel file to work...
Use nested iff.
I dont think it will work