Creating a Measure: Max Sale Amount from Last Three Months — Oracle Analytics

Oracle Analytics Cloud and Server

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
2
Views
1
Comments
1008490
1008490 Rank 3 - Community Apprentice

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

  • Hi,

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