Skip to Content
avatar image
Former Member

Total to be displayed in the end of the dimension

I am using a hierarchy dimension in my crosstab and restricted the dimension to a list of values. When I display the total of the dimension in the crosstab, the total is getting displayed in the parent node of the hierarchy. I want the total to be displayed in the end?

overall-result.png (35.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Mar 27, 2017 at 11:37 AM

    Pallavi,

    As Mustafa mentioned already, you may need to move the Result in your query from left to right in the query settings:

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 27, 2017 at 09:01 AM

    Hi Pallavi,

    If your data source is a BEx Query, you can either change the totals position in the query definition itself, or in Design Studio you can try the following script code:

    DS_1.setTotalsPosition(Axis.COLUMNS, TotalsPosition.AFTER);
    

    Regards.

    Mustafa.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks for the reply, Mustafa.

      But this solution is not having any effect on the dimensions which has hierarchy.

  • Mar 27, 2017 at 01:06 PM

    Hi Pallavi,

    After testing I see that the scripting approach alone does not have the desired effect. You need to update the BEx Query directly. In addition to the settings Agata has suggested, you also need to make the following setting for the dimension with hierarchy:

    Regards,

    Mustafa.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 28, 2017 at 05:52 AM

    Thanks a lot guys for the help.

    Pallavi Indukar A

    Add comment
    10|10000 characters needed characters exceeded