Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all, I'm trying to calculate the year to date (YTD) from the data load editor.
I have a month and year date field (myDate) and another field with the order of the dates from myDate. So the most recent month and year is zero in order, last month is 1 and so on for 24 months.
How do I create a YTD field in the data load editor so that every month that I reload with new data that field updates.
Thanks in advance.
Best,
Guille
Hi,
You can create YTD (using Set Analysis) across the required dimension in straight table. That would be the best practice.
Thanks,
Usama