Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 212 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Accrual Report / "Time.Month" Formula / report formating
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
Answers
-
Hi Marius, To better serve you, I have moved your post to the Reporting and Analytics for HCM forum to get more experts eyes on it. Thank you.
Moved to: https://community.oracle.com/customerconnect/discussion/824142/accrual-report-time-month-formula-report-formating
0 -
Thank you @John Hung-Oracle
0
