Transpose rows to columns for Ratings

Question

I want to show the ratings of two specific performance document section names in columns.

I named the header like the section name.  I used a "CASE WHEN" statement for "Average Manager Section Rating" and "Average Calculated Section Rating"

I tried these two formulas:

CASE WHEN "- Performance Document Section"."Document Section Definition" = ' Germany Leistungsbeurteilung' THEN "- Performance Rating"."Average Calculated Section Rating" END

And with RCOUNT

CASE WHEN RCOUNT("- Performance Rating"."Average Manager Section Rating" BY "- Performance Document Section"."Document Section Definition") = 1 AND "- Performance Document Section"."Document Section Definition" = ' Germany Leistungsbeurteilung' THEN"- Performance Rating"."Average Manager Section Rating" END

It works, when I have the section Name inside the report, but it will show several rows for the rating.

Hiding the column "name" will lead to the same situation. Removing the column "name" will change the results for the calculcated section ratings.

Only the formatting is exactly the way we want it. Rating are all in one row. Values are not correct.

I am using "Workforce Performance - Performance Rating Real Time"

Appreciate every help.

Sa_De_Or · Answer

Hi Guarav, thanks for your reply.

I created a pivot table and need to adapt some things, which I don't know how to do:

- for the blue document section "Individuelle Ziele", I want to only have "Average Calculated Section Rating"

- for the green document section "Leistungsbeurteilung" , I want to only have "Average Manager Section Rating" and "Average Calculated Section Rating"

How can I solve this?

Gaurav Bharadwaj-Oracle · Answer

Hello @Sa_De_Or,

I understand you are asking a question regarding Converting rows to columns in OTBI.

You need to use the Pivot Table view to do this, please check the following tutorial :

https://www.youtube.com/watch?v=l_9Rh52Qq5w

If my response has answered your question or assisted you with your concern, please click "yes" below to accept the answer or comment with any additional queries. You can also read the Cloud Customer Connect Guidelines for Accepted Answer

Regards,

Gaurav