Time Intelligence Function - Do I need a calendar?
Hi, I am a bit confused if I would require a calendar for my data analysis. I viewed a post similar to my question but it did not give the answer I needed. My data is extracted from SAP to MS Excel as the example shown below. I am trying to perform an analysis of my current year actuals vs current year budget vs previous year actuals for each product group in respective to their country. This should be done as per the year to date figures. As you can see, my data does not have a calendar (day month/year) for each sales. Is this necessary? If so, what are my options? Posting Period Current Year Actual Current Year Budget Previous Year Actual 1 10,000 9,000 8,000 2 7,000 8,000 8,000 3 6,000 5,000 7,000 4 6,000 6,000 5,000 5 4,000 7,000 5,000 6 12,000 10,000 11,000 7 13,000 12,000 10,000 8 9,000 6,000 7,000 9 7,000 5,000 8,000 10 5,000 6,000 5,000 11 8,000 7,000 5,000 12 10,000 7,000 5,000 I'm currently trying to figure out how I can calculate the year to date values for each criteria (CY actuals vs CY budget vs PY actuals). With this, I want to summarise the data for each country/product group. I would really appreciate if you could help. Many thanks.