Hi Jheng,

Here’s the documentation for conditional layouts in the cube, which tells you exactly how to set this up for the cube.

Kind regards,

Tim de Lang

Hi Tim,

Found it thank you!

By the way, have another question on cube is it possible to change the layout between column and row?

currently in my cube it is like the first image i sent, 

But how to make the average in rows and the year/month in column>

Thank you

Hi Jheng,

Good to hear.

To pivot that cube you’d need to flip the categories and series which is detailed here in the documentation on the cubes.

Kind regards,

Tim de Lang

Hi Tim,

I actually tried to flip it but the result turns out like this, shows in column 

So what I’m trying to achieve is the Values to be in rows and year/month in column, like the screenshot i sent above.

Thank you

Hi Jheng,

it looks like you don’t have the KPI’s set as categories.

Kind regards,

Tim de Lang

Hallo Tim,

I cannot set KPI values as categories

Currently it shows like this 

But we want to show like this for example 

Thank you

Hi, 

What Tim means is that you should put the Year and Month in the series. But for you, that will not work.

Because then the type of kpi 1,2,3,&4 would need to be a dimension. In your view, you now seem to have for 1 row,

But to create what you want, you would need to have it in the view like this;

And then in your cube view, year and month would be in the series and the kpi_type in the category and then the kpi_value in the value box.

That will do what you want.

Hi Sebastian,

Thanks I’ll give this a try.

So I need to change the approach on my view table to add in kpi_type column, so data will be redundant in this sense.