Hi all,
I would like to create a matrix report type in Power BI but son't know if this will be possible.
The report should show a sum of sales amount per country and per year grouped on a monthly basis (for references of the column names see screenshot from dropbox).
Column O shows the sum of the previous year and column P shows the sum for the previous year but for the same amount of months as the report will show for this year (YTD = year to date), for example if we are March, YTD will show sum of months January and February.
For the previous years it should show all sums per customer of the months from January till previous (last) month (YTD = year to date).
This should be grouped per country (line 4 till 27 and line 28 till 30) and show totals per country and then show at the bottom the grand total (line 31).
Column T = (S4-P4)/P4
Column U = (R4-D4)/D4
Can you please help me out and let me know if this report is possible?
See screenshot here on how it's made in excel: https://www.dropbox.com/s/3rn8elzaw7wk03j/screenshot.png?dl=0
Thank you.
Best regards,
Roberto
