Pivot self-assessed tax amount from a column to a row in an OTBI Report
SummaryPivot self-assessed tax amount from a column to a row in an OTBI Report
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?