Last Year In Universe
I need to calculate Last Year Sales in the universe level.
In universe I force the sales current to have a prompt and for last year I say that is the prompt -1 but with this I have two lines.
|Year||Sales Current||Sales Last year|
My goal is to have all in same line like this:
|Year||Sales current||Sales Last Year|
It's possible to do it?
One way of doing it is to create two seperate tables and place them next to each other
First table will have
Second table will have
|Year||Sales Last Year|
Then Hide the Year in the second table.
Align the second table next to the first table.
|Year||Sales Current||Sales Last Year|