Forum Discussion
Advanced pivot? Advanced matrix view?
Hi everyone I currently have data in the following format where each company can have multiple packages, sale currency and billing currency. Crucially the same company could within a particular m...
Thanks for your reply. Unfortunately your solution doesn't work when a company has multiple sale or billing currencies within the same month. I've made my requirements clearer to show that I would like these to have their own rows so that within each month it's possible to see what's happening for each company in each combination of currencies - is this possible?
Hi fbrickley,
Perhaps you can consider moving the currency fields to row fields instead of column fields. Then power bi matrix visual will group your records based on company and currency fields.
Regards,
Xiaoxin Sheng