Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 218 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 82 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
How to do this in Pivot graph in OAS BI Tool

User_65OG0
Rank 2 - Community Beginner
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
Tagged:
0
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