How to do this in Pivot graph in OAS BI Tool

Question

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

User_65OG0 · Answer

@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

)

Wayne Van Sluys · Answer

how are you getting the YoY?  Semantic Model or DV Calculation?

User_65OG0 · Answer

Hi All , any solution for this?