Start a new topic
Answered

How can I merge actual data in financial year, with Plan data in calendar year, and create plan vs actual data as per financial year

How can I merge actual data in financial year, with Plan data in calendar year, and create plan vs actual data as  per financial year as per the below scenario from the attached files?


Scenario:

Projection – Plan sales data is in Calendar year, monthly data.

Actual sales data is in financial year, monthly data.

xlsx
(1.46 MB)
xls

Best Answer
1 Comment

Answer

Please refer to the below knowledge base

http://support.smarten.com/support/discussions/topics/9000056177 


Login to post a comment