Custom Calculated Column in Design Studio based on another value

[former_member272256]

Hi Expert,

I have a requirement were we need to create a column in cross-tab like below.

The initial value for cross tab will come BEx. And we need to create a calculated field in design studio level.

In the below sample, column A and B will come from one query and column E and F will come from another query.

we need to calculate the column C.

Please provide your suggestion. We expecting to do this calculation in Design Studio level.

Thanks!

Regards,
Ramesh J

[MustafaBensan]

Hi Ramesh,

You have mentioned that "column A and B will come from one query and column E and F will come from another query." Are you aware that you cannot assign more than one query to a Crosstab?

Regards,

Mustafa.

[former_member241445]

Hi.

Maybe you can use the merge datasource of discovery.

[former_member272256]

Hi Tammy,

The once which shared could helps to calculate with the value in same Datasource. But here we need to pull a value from another datasource and need to do the caculation.

Thanks!

Regards,
Ramesh J

[former_member272256]

Hi Rene,

Will check.

[TammyPowlas]

Hi - this can be done at runtime - have you tried that? See https://blogs.sap.com/2015/11/27/custom-measures-calculations-sap-design-studio-16/

[former_member234401]

Hi you have an option to mark the two KF and then right click

Or create the calculation in AAO and use the smart copy/paste function to move the DS from AAO to Design Studio

But if you reset the datasource in Design Studio afterwards - the calculations will be removed

/René