I'm building an OTBI report to based on Accrual Real time subject area, with the goal of displaying accrual balances.
To have a report that makes sense I used Pivot Table as a View mode instead of table; see bellow a snip
As you can see I moved in the pivot columns the Accrual Type and the Month. At the same time in rows I'm also using Calendar Year which is prompted. The issue is here:
When the user filters the report for multiple years; the year is also displayed in the Month columns.
We would like to keep in column only the calendar name of the month; and have the year in row.
The subject area does not contain a "Time.Month Name"; and the month column is display in the format that can be seen above YYYY / MM.
Is there a way to achieve this via a formula?
If yes can you explain how? Or provide a snip?
Thank you,
Marius
