Creating column with previous month
I have this model with year-month (attributes) in the rows and KPIs (measures) in the columns. A simple tabular display of the content thereby obviously shows the KPI-values / month (and other attributes).
What is missing - and which I cannot figure how to do - is how to create columns showing the KPI-values / previous month (i.e. month - 1). To clarify the result would thereby look like this:
Sales Prev Sales
January 2014 100 160
February 2014 105 100
March 2014 110 105
I figure it must actually be pretty easy using restricted and/or calculated columns, but just cannot figure out how to do it (maybe I ate too much for x-mas). I much appreciate hints.
You can simple create two views with the actual and prev. month sales and union these values to get them next to each other. This is method described in following post: