Calculate Current Month, Last year same month, Previous Month, YTD, for [Cross Calculation] on SAC

[Charlielin]

Hi Experts,

  I am facing a requirement where I need to calculate Input Month, Last year Input month, Previous Month, YTD of income statement figures(SAP COPA Data) all on the same report using SAC(as below), the source data is from Datasphere.

 Cross Calculation is used

User will specify an input [Year/Month] at run-time. 

Please share your experiences on how to achieve this, thanks a lot !!!

＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝

Q2: We have to calculate the weighting for each line, is that possible ?

[Mark_P_Burke]

@Charlielin. Use the %GrandTotal() or GrandTotal() Mathematical Functions.

[N1kh1l]

@Charlielin 

Your Input Year month should be Date filter. Rest all can accomplished using dynamic time restricted measures.

Previous Month: Make the selection as below

Previous Year Input Month: 

YTD:

Hope this helps !!

Nikhil

[Charlielin]

Thanks for replying, however users will dynamically enter a Year/Month instead of just using the system date. Currently, I managed to achieve this by creating Input Parameters + set flags dynamically based on user input for Calculated Column