Forum Discussion

sam_gift's avatar
sam_gift
Helper I
2 years ago

Data Modelling for Fact Table which refers to a same column for Revenue, Standard Cost

Hi, the fact table in my current model have a column called reporting_currency.

and there is an other column called rep_id

If the rep_id is 1,2,3,4 then reporting_currency is for Revenue.

If rep_id is 5,6,7,8 then reporting_currency is Standard Cost.

 

What is the better approach to maintain the fact table when I want to create different columns for Revenue and standard cost.

The reason, I am asking is I want to calculate SGM % which is DIVIDE((Revenue-Standard Cost)/Revenue) as a column to establish the Static Segmentation process for percentage bucketing.

1 Reply

  • Hi,

    Share data in a format that can be pasted in an MS Excel file and show the expected result.