Forum Discussion
Calculating MTM Value based on Month End Position with Last Price
EdwardNg , Please find the attached solution after the signature.
Create common dimensions, Joins, and few measures
for the qty, can we do live-to-date balance instead of just the balances for the month?
amitchandak thanks for the prompt response.
Also, if i have additional fields in the transactions i want to display in the summary, it gives me a problem. For example if we have product description, it gives the permuatation, as below:
Could you kindly advise? appreciate your thoughts on this.
Many thanks
- amitchandak
Super User
EdwardNg , one product has two description ??
each product only has 1 description. But this is probably just the simplified version. There could be other fields like company, etc. So each product could be have different values for company. hope this is clear.