Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

Tags:
Former Member
Former Member replied

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:

Implementation of WTD, MTD, YTD Period Reporting in HANA using Calculated Columns in Projection

Best regards

Patrik

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question