Profits and Loss statement with a level or Hierarchy

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

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,
Can you guys help me?
Thanks a lot

Hi @pedroccamara,

See if this is helpful to you

1 Like

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