Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!
Dynamic headers in OAC classics report
Summary:
Dynamic headers in OAC classics report
Content (required):
We need dynamic column header in classic report ,eg.
header1 = current date -7,header2 = current date-14 ..... etc.
for example : current date = 09Dec2022
header1 = 09Dec2022-7 = 02Dec2022
header2 = 09Dec2022-14 = 25Nov2022
We tried using union report to achieve same.
since in main report(data report) data types for columns are mixture of number and varchar which is used in further calculation can't be change data type so union report (for header) is not working.
Any suggestion on same.