Skip to Content

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

How to Calculate Average for Dimensions based on a Year

Hi Experts,

I have a requirement where I need to display Average changes across Source in a Year in webi report based on HANA Universe.

I have 4 columns Source(String), Change From(String), Change To(String) and Date(Date(MMDDYY)).

Columns Change from and Change To  values are like below

Changes From       Changes To

0001                         0002

0001                         AP17

0014                         0013

GEPB                       GECB

Any help would be highly appreciated.

Thanks in advance.

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