Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

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
41
Views
2
Comments
Dorothy Teoh
Dorothy Teoh Rank 2 - Community Beginner
in Oracle Analytics Forum

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 & AI 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