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.

[Mark_P_Burke]

For Q2, use the %GrandTotal() or GrandTotal() Mathematical Functions.  See SAC Help.Sap.com
If this is all relative to Net Income as total, then divide each row by Net Income.

GrandTotal(Account)

Returns the grand total of all the Account values in the result set. Filters are included in the calculation of the grand total.

GrandTotal(Sales) returns the aggregated value of Sales.

%GrandTotal(Account)

Returns the percentage of the grand total that each value represents.

%GrandTotal(Sales) returns the percentage of the grand total that each value represents.

[Charlielin]

Apologized that I've given a bad example, the actual situation is that we have to use "Cross Calculation" to populate different measures on the row instead of just a single [account] dimension, that's why it's kinda complicated

[Charlielin]

I've refreshed my screenshot to make it more clear