Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Pivot self-assessed tax amount from a column to a row in an OTBI Report

Summary

Pivot self-assessed tax amount from a column to a row in an OTBI Report

Content

Currently, we have an OTBI report using the subject area “Payables Invoices – Transactions Real Time”.  Within this area there is a measure for the invoice self-assessed tax line amount ("Invoice Self-Assessed Tax Line Amounts"."Line Self-Assessed Tax Amount").   Instead of displaying as a column, the user is requesting it be displayed as a row, similar to how the UI will display the accounting lines on the invoice. 

Is there a way to pivot the self-assessed tax line to a row where the class meaning attribute ("- Subledger Accounting Journals Details"."Accounting Class Meaning") is used to display the self-assessed tax amount? 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!