topic Pivot table question in App Development

Pivot table question

Polido — Fri, 04 Aug 2023 12:20:16 GMT

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!

Re: Pivot table question

JHuis — Fri, 04 Aug 2023 12:56:59 GMT

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?

Re: Pivot table question

Polido — Fri, 04 Aug 2023 21:35:05 GMT

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! 🙂