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

[sam_gift]

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.

[Ashish_Mathur]

Hi,

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