Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone.
I've tried to search for similar questions / solutions but I didn't found one that could help me. Sorry for this and for maybe being a noobie question.
My aim is to create a table with last 12 months on top (this is already done) and then on the left 9 different measures and the last column should be the total of the measure for the last 12 months. Something like this:
2022-08 | 2022-09 | ... | 2023-08 | Total | |
Sum total (kWh)/t | 10 | 15 | x | 5 | 30 |
Sum electrical energy (kWh/t) | |||||
... | |||||
... (9 measures in total) |
But instead, it's appearing like this:
I tried doing this with a pivot table but the master measure only goes into the field "values".
Is there a diferent way to do this? Am I doing something wrong?
I would appreciate some help, thanks in advance!
Turns out it was only dragging and dropping the values into the other side. Like this:
Didn't knew about this functionality. But it's solved now! 🙂
i would reccommend to get a dimension field. Also the measure total is not neceserry if you add an good dimension.
Is there no dimension where you can build the visualisation?
Turns out it was only dragging and dropping the values into the other side. Like this:
Didn't knew about this functionality. But it's solved now! 🙂