Forum Discussion
Matrix into P&L Statement
Hi community,
Currently trying to turn a matrix into a P&L statement. Have been lurking here for a while so I've seen a lot of recommended video's and posts but I'm still struggling with the fact that there are cells showing blanks. I would like for the matrix to only show the values.
Any help would be greatly appreciated!
Thanks in advance.
Cheers,
Dexter
Hi Dale,
Thanks for your reply.
I figured it out:
Now I'm trying to subtract the total of 'Uitgaven' from the total of 'Omzet'!
Cheers,
Dexter
5 Replies
Hi community,
Currently I'm trying to turn the matrix visualization into a P&L statement. I've seen a lot of recommended video's and posts so I'm progressing. Although now I'm struggling with the fact that my matrix is showing rows that don't have values and also don't have to be shown. Can't figure out how to insert an image so here's the link of Dropbox: https://www.dropbox.com/s/9e8yuhtnm1epecj/Matrix.PNG?dl=0.
Any help would be greatly appreciated!
Thanks in advance.
Cheers,
Dexter
Hi Dexter,
I have to consult the idea P&L. What's relationship between Matrix and P&L?
Just see from your image, you put the wrong hierarchies in the Row of the Matrix. The parent level has itself as the child level. What's your data structure? What's the expected result? Can you share a dummy sample?
Best Regards,
Dale
