How to Calculate Average for Dimensions based on a Year
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
Any help would be highly appreciated.
Thanks in advance.