SAC - Add measures in rows and columns at the same time

[cristina_talmaciu]

Hi,

I'm using live connection to DWC and I'd like to add in SAC a table with measures in rows and columns (the measures like Gross Margin, Net Contribution etc in row and the PY, CY, variance CY vs PY in column). It seems that SAC allows to add the measures in row OR in column but they can't be split across rows and columns at the same time.

Is there any solution to this limitation?

Kind Regards,

Cristina

[former_member590506]

Hi Cristina,

In case of two measure structure or say measure in both column and rows , you can try with “cross calculations” and hope it will solve your issue.

Please let me know if I have not understood your problem correctly.

[cristina_talmaciu]

Hi,

I think cross-calculation option is available only in models based on data acquisition connection.

Here I can't see any option:

[Eliram_Lugassi]

Hi evreybody.
i'm using an acquired model.

i also experienced this question, i have cross calculation that i need to preform to each period of time (current month, YTD, full year).

i've previously created them as measures and placed cross calculation underneath but now that i have measures in rows, i don't know how to solve this