Move totals to left i SAC

[Verakso]

Is it possible to have the totals in the beginning of a table in SAC, instead of default right end?

I can’t find any settings in SAC to support that, and I even tried changing the result location in the BEx Query to Left, but that did not do the trick either.

//Thomas

[MJUDI]

To add to what Jay already suggested, I workd around this by turning the time dimension in the coliumns into hierarchy. This will allow you to show the totals, whic is the highest node, on the left instread of right.

[Verakso]

This could seem like a solution, I'll give it a try.
Unfortuneatly, not all dimensions is suited for hierachies.

[Jay_Gandhi]

Hi Thomas,

Unfortunately there is no straightforward way to do this.

You can do this in the rows by changing the 'arrange totals/parents' option to either be on the top or bottom.

For left-to-right, generally you'd need to do a custom sort, and the total would need to be a calculated measure and everything would have to be custom sorted. But that would not completely meet the above use case.

Jay

[Verakso]

Well off to Idea Place when that is up and running again then.