Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 281 Oracle Analytics and AI News
- 57 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
- 105 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Quarter Over Quarter difference / percentage of difference in ODV?
Summary
Quarter Over Quarter difference / percentage of difference in ODV?
Content
Ho can I show Quarter Over Quarter difference / percentage of difference in ODV?..
70
| Region | Q1FY17 | Q2FY17 | Q o Q |
|---|---|---|---|
| APAC | 100 | 80 | 20 |
| EMEA | 250 | 170 | 80 |
Answers
-
if You are interested specifically in those two quarters you could "fix" them and then write the formulas.
You could create 3 new fields like
E.g.
"QTY Q1" As "FILTER( Quantity USING Quarter = 'Q1FY17')"
"QTY Q2" As "FILTER( Quantity USING Quarter = 'Q2FY17')"
"Q on Q" As "QTY Q2"-"QTY Q1"
0 -
Can we use Presentation variable kind of thing in ODV, where we can capture the Filter values from the user and change the quarters to display accordingly?
If yes, how please..
0 -
There are no Presentation/Session Variables in DVD at the moment.
0 -
If you got the answer to your question you can maybe close the thread? It will help others with same/similar questions, right now it's still This question is Not Answered.
0