Forum Discussion
dmoney7612
4 years agoHelper II
Matrix question- Excel exporting
I have the below matrix and was trying to figure out a way to export to Excel in the same format with all the month columns listed out. As you can see in the 2nd snippet, the months are broken out in...
- 4 years ago
Hi dmoney7612,
When you export matrix visual, data gets unpivoted in the exported excel.
You need to make a pivot table after exporting data into excel to get the same matrix visual look.
Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂Regards,
N V Durga Prasad
nvprasad
4 years agoSolution Sage
Hi dmoney7612,
When you export matrix visual, data gets unpivoted in the exported excel.
You need to make a pivot table after exporting data into excel to get the same matrix visual look.
Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂
Regards,
N V Durga Prasad
- dmoney76124 years agoHelper II
That's what I figured. So there is no work around or another visual that would export better?