I’m building a pivot table in Oracle Analytics Cloud with Month on columns and Category on rows, showing three measures under each month: YTD Previous Year, YTD Current Year, and Evolution. For YTD Previous Year, I’m using the formula Filter(PERIODROLLING(SO Value, -24, -12, Month) using Year(Date) = @calculation("PreviousYear")). The problem is that all rows for YTD Previous Year show the same value unless I add another measure (like Quantity or Value) to the table, sometimes the YTD Current Year also messes up (Formula: TODATE(SO Value, Year) ). How can I make this measure return different values per category without having to add another measure as a workaround?