Pivot Table Issue — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Pivot Table Issue

Received Response
1
Views
2
Comments
3193829
3193829 Rank 5 - Community Champion
edited Aug 13, 2024 6:12PM in Oracle Analytics Cloud and Server

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.

Capture1.JPG

Thanks & Regards,

K

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    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.

  • 3193829
    3193829 Rank 5 - Community Champion

    Hi Gianni,

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

    Regards,

    K