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

How to tabulate YoY sales with budget by given cut off month ?

Received Response
33
Views
2
Comments
Dorothy Teoh
Dorothy Teoh Rank 2 - Community Beginner
in Oracle Analytics Cloud and Server

Summary

How to tabulate YoY sales with budget by given cut off month ?

Content

Dear all,

Management want to have analytics with Year on Year comparison with a cut off month to compare sales revenue and budget.

I tried using presentation variable and

image

This is generated in BICS.  Due to same year, budget is stacked in same year and the group is with different color.  Anyone has experience to delivery such requirement ?

Please help.

image

Answers

  • FTisiot
    FTisiot Rank 6 - Analytics Lead

    I suggest you to create 3 new measures:

    1) Sales Prev Year with formula FILTER(Fact.Sales USING Dim Date.Year=2016)

    2) Sales Curr Year with formula FILTER(Fact.Sales USING Dim Date.Year=2017)

    3) Budget

    and show the 3 in a bar chart

  • Dorothy Teoh
    Dorothy Teoh Rank 2 - Community Beginner

    Hi,

    I did the mentioned steps to differentiate three measurement.  However, when sales and budget are in the same year, it will stack into one bar.  I want to display them in three separate bars with same products in same color; just like example in good old excel sheet.

    Thanks, Dorothy