Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Running Balance | Outside Applied Filter
Greetings Community, I'm trying to build a Calculation Named "Balance", wherein it needs to consider Transaction Amounts outside the applied Date Filter since it is running total.
I was wondering what is the possibility using inbuilt functions? Because I need Date Filter to show only filtered transactions but this calculation should consider data from before the Transaction Date.
Thank You.
Answers
-
Hi @Vismay Barot,
Yes, you are correct. Ideally you need to define a calculated measure as per your requirement which you can use as a readymade column in your analysis and while defining the measure, need to set the aggregation level, associated dimensions etc. in such a way that it'll bypass the report level filters.
It might be bit tricky. for example the report has filter for a week where as the measure is showing data for month etc.
Please find below the Oracle document of available functions within OAC:
Hope this help.
Cheers,
0 -
Thank You @Bhaskar Konar for your kind response, I've defined Balance as a Running Total on Oracle SQL Level.
But now the problem is, how do I show the Balance Value of Latest Date of particular Account, I tried using this "Last" but seems disabled:
And also tried using formula but errors out:
Basically, I'm not intending to use Transaction Date in the Visual, just simply want to show the Balance for the Latest Transaction Date Row.Please let me know how this can be overcome.
Thank You.0
