Forum Discussion
Setup Ideas
I have created a matrix that identifies COGS at a moment in time (cost as of today). What I now need to do is change the cost of the goods based on when the product was sold. How would you recommen...
Hi Anonymous,
If you want to get the visual like the picture right side, you may shape your data model in Query editor then create a matrix.
1. You need to create a custom colum YearMonth.
2. Then pivot the column YearMonth with the value.
If you need further help, could you share some data sample and your desired output so that I can help you.
Best Regards,
Cherry