Profits and Loss statement with a level or Hierarchy

Data Visualizations
1

Hey guys
I’d like very much to learn how to do this. Not sure the best approach for it.

P&L
P&L883×497 58.8 KB

I don’t think i have to add columns on my fact table.
Maybe you guys find a better approach for it.
This is how my data looks like,
Capture11
Can you guys help me?
Thanks a lot
Pedro

2

Hi @pedroccamara,

See if this is helpful to you

1 Like
3

Yes @Melissa
It tells me the way to do it. Now i will have to make some changes on my fact table.
Thanks a lot for your help
Pedro