Performing Calculations

[meghanshbajaj]

I am trying to calculate the difference in (Number of Employees) for each year. Example: (Number of Employees for 2018  - Number of Employees for 2017). I am using the Dimansional field of Year and Fact (measure) of Number of Employees. Kindly help. Thanks.

[MFGF]

I am trying to calculate the difference in (Number of Employees) for each year. Example: (Number of Employees for 2018  - Number of Employees for 2017). I am using the Dimansional field of Year and Fact (measure) of Number of Employees. Kindly help. Thanks.

Hi,

What sort of package are you using - a flat relational package or a dimensionally modelled OLAP package? The answer will be different for each.

Cheers!

MF.

[meghanshbajaj]

Hi, i am using flat relational package. Thanks