Pivot Table Issue

Question

Hi All,

I have requirement, where in i have to add a metric across a dimension in the pivot table, along with other metrics. But i am facing issues doing so. Is there any other way to achieve this. Below is the screenshot of what is expected.

Thanks & Regards,

K

3193829 · Answer

Hi Gianni,

Thanks for the reply, it worked . I am marking your reply.

Regards,

K

Gianni Ceresa · Answer

The pivot will always pivot everything, so if you add "Dim1" as columns all your measures will be replicated for each value of Dim1.

Assuming you know in advance that Dim1 has only values A, B, C you can create 3 measures representing these 3 values (using FILTER BY for example). In that case it isn't a pivot anymore in the end, a table could also give you the same output.