Hi all - First time here. Hopefully what I am asking can be done
I have 6 products with the following metrics: Units, Revenue, Calculated local Price, Calculated price in USD using todays Canadian Dollar to USD rate, Total Addressable Market size, and Unit Share calculated.
I would like to see how Product Mix, Pricing, and Volume (split between Market growth and unit share gains) and finally Foreign Exchange rate impact the Revenue from one period to another. I have been stuck on this for weeks!!!
The file I am using is attached. I really hope someone can help! Thanks
Moderator Note: The attachment has passed security scans at virustotal.
I have 6 products with the following metrics: Units, Revenue, Calculated local Price, Calculated price in USD using todays Canadian Dollar to USD rate, Total Addressable Market size, and Unit Share calculated.
I would like to see how Product Mix, Pricing, and Volume (split between Market growth and unit share gains) and finally Foreign Exchange rate impact the Revenue from one period to another. I have been stuck on this for weeks!!!
The file I am using is attached. I really hope someone can help! Thanks
Moderator Note: The attachment has passed security scans at virustotal.
Attachments
Last edited by a moderator: