Profit & Loss Statement

Data Visualizations
1

Hi guys,
I’m doing this report above, like Sam taught us, with a supporting table ( https://portal.enterprisedna.co/courses/unique-analytical-scenarios/lectures/11980964).
So far so good, all done, but…
All the lines in this report are measures because we want specific results. Maybe i should add a supporting column on the table, i don’t know.
So, it’s a matrix visual and i would like, 4 or 5 more columns for each measure, for LY results and variations as well as budget totals. Like this:

Capture
Capture837×145 25.5 KB

Those 2 columns on the right are from a table visual, but i have to add 3 more columns (3 more measures). And the same for every measure on this P&L for every measure i’ve build. Which means 18 lines on this P&L times 5 columns means 90 measures.
I don’t think this is the way i should do it but can’t think on any other way.
Can you help me?
Thanks a lot everyone
Pedro

2

Ok guys,
Again, i’m sorry to bother you and let me tell you how i did this. It’s not perfect, far from it, but for now it solves my problem and with just 5 measures instead of those 90!!

Capture2
Capture21037×109 23.2 KB

I had to change the supporting table and i’ve done 2 matrix, but the 2nd without the row headers. It will work ONLY for now. But i guess i have to imagine a better way to show these numbers.
Thanks guys.
Pedro