How to get "full control" on columns design in a SAP Analytics cloud table ?

[Guillaume_P_FR]

Hello.

I'm trying to build a table in a planning story with the below requirement for columns sequence : 

		Version	Actual													Actual		Forecast		Forecast
		Measure	Granted amount	Consumed												Consumed	Remaining	Consumed		Consumed
		Date	2023	202301	202302	202303	202304	202305	202306	202307	202308	202309	202310	202311	202312	2023	2023	202401	--->	202412
Project	Accounts
ABCD	65000000		10 000 000	100 000	100 000	100 000	100 000	100 000	100 000	100 000	100 000	100 000	100 000	100 000	100 000	1 200 000	8 800 000	120 000		120 000
	66000000
EFGH	65000000
	66000000

I'm exploring what can be done with cross calculation with mitigated success so far.

Would be great to find a way to be able to manage entirely each column independantly, because the table is not "symetric", and granularity is not constant ...

The first measure "granted amount" is used only in first column of data.

All actuals columns are coming from an S/4 Import connection.

If i just drag and drop version / date / measures in columns I get a neverending list of all possible combinations between those 2 dimensions and measures.

Is there a way to force measure to behave like a dimension ?

There is several versions of forecast, driven by an input control in the story. And there is a period filter that should be used to offset all date selection.

The goal is also that forecast (version) columns are dynamic and actuals columns always stay actuals of course.

Thanks in advance for your advices.

(EDIT : picture of the table added, maybe more readable ... green is actual, yellow is plan)

Regards.

Guillaume P.

[N1kh1l · Accepted solution]

@Guillaume_P_FR 

The table widget is kind of left out in terms of innovation. The only options you currently have are below and non of them are flexible.

• SAC Forecast layout in Table
• Copying Actual Data in Forecast version when period becomes Actual. Periodic data copy required but this is the method which works best.
• Advance Filtering.

None of the above give you full layout control.

Br.

Nikhil

[Guillaume_P_FR · Accepted solution]

Thank you very much Nikhil. Once again I was more or less waiting a confirmation that the table widget is full of limitations more than a real solution. In BPC managing this kind of need takes around 5 minutes using dimensions selection, formulas on EPMOlapMembers (and everything stays dynamic according to selection). Have a nice day and thanks again for helping. Rgds. Guillaume P.