OAC Calculations

Julianne

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?

Gianni Ceresa

Hi,

Welcome to the Oracle Analytics community and forum.

What is your workbook based on? A dataset or a subject area?

Julianne

https://community.oracle.com/products/oracleanalytics/discussion/comment/69918#Comment_69918

Thanks!
It's combination of both (dataset and subject area), is that an issue?