Hi,how do I use 'named calculation' to create column that shows percentage of sales amount increment between 2 different years? Below is the report structure done using SSAS

See more:

Microsoft

analysis

SSAS

Hi,how do I use 'named calculation' to create column that shows percentage of sales amount increment between 2 different years?

Customer = Row Labels
Fiscal Calendar Year & Month = column labels
Values = Net Sales Value, Calculated Profit

For example in 2013 the sales amt = 1050, in 2014 the sales amt = 1000.
Increment will be 50 equivalent to 5%