Forum Discussion
MTD calculated column
Hi, I have source data amounts presented in year-to-date (IBM Cognos) and are trying to create a calculated column in the fact table that is presenting the month-to-date value. Example below: ...
v-xiaotang
Community Support
Community SupportHi Anonymous
You could create create an independent MTD column, please provide more details, then we can readjust your columns according to your needs.
(1) a sample file, you can replace raw data with bogus data to protect your privacy.
(2) or provide some sample data that fully covers your issue/question
(3) give your expected result based on the sample you provide
(Kindly note: Please ensure the data in sample is concise and representative)
Thanks.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.