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.
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.
Attachments (2)
Plan Data.xlsx
1.46 MB
Actual Data.xls
4.09 MB
0 Votes
Smarten - Solution Team posted over 4 years ago Admin Best Answer
Please refer to the below knowledge base
http://support.smarten.com/support/discussions/topics/9000056177
0 Votes
1 Comments
Smarten - Solution Team posted over 4 years ago Admin Answer
Please refer to the below knowledge base
http://support.smarten.com/support/discussions/topics/9000056177
0 Votes
Login or Sign up to post a comment