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.
Quote from: meghanshbajaj on 14 Aug 2018 10:43:14 AM
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.
Hi, i am using flat relational package. Thanks