Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 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
How to do this in Pivot graph in OAS BI Tool

Hi All,
Please see the screenshot I am using pivot graph . But yoy and yoy% its repeating same in two columns, what i want yoy and yoy% to reflect after May-25 , so its like category, cur, may-24, may-25, yoy , yoy%
I am using expression filter to show latest month available data set and previous year month data. example if my dataset has may-24 to may-25 im showing this two month only.
Right now, im seeing same value in both month
Answers
-
Hi All , any solution for this?
0 -
how are you getting the YoY? Semantic Model or DV Calculation?
0 -
@Wayne Van Sluys its a calculated field . Below is the logic
AGGREGATE(
SUM(
CASE
WHEN YYYYMM
= AGGREGATE(MAX(YYYYMM)
BY ENTITY
THEN CUR
ELSE 0
END
)
BY Category
) -AGGREGATE(
SUM(
CASE
WHEN YYYYMM
= AGGREGATE(MAX(YYYYMM)
BY BY ENTITY - 100
THEN CUR
ELSE 0
END
)
BY Category
)0