Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Creating a Measure: Max Sale Amount from Last Three Months

Received Response
1
Views
1
Comments
1008490
1008490 Rank 3 - Community Apprentice
edited Aug 13, 2024 6:20PM in Oracle Analytics Cloud and Server

Hi All,

I have a sales table, Now I need to create report like below Columns

Month Name, Sale Amount, Max sale amount from last three months

Please suggest how can I Create measure for Max sale amount from last three months

Thanks in Adavance

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    did you try by setting the aggregation to MAX on your sale amount column and filter the analysis on the last 3 months?