Forum Discussion

Mai_Nashaat's avatar
Mai_Nashaat
Helper II
5 years ago
Solved

Grand Totals colum

Hi everybody,

 

I need to change the place of grand totals from the end of the matrix to be the first column in the matrix.

Any idea how to make this

 

Thanks in advance,

Mai

  • Hi Mai_Nashaat ,

     

    The current version can not change the position of "Grand total", try to find a custom visual in appsource .

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

7 Replies

    • Mai_Nashaat's avatar
      Mai_Nashaat
      Helper II

      I want to do that for grand totals

      It exists at the end of the table I want it to be the first column

      • v-lionel-msft's avatar
        v-lionel-msft
        Community Support

        Hi Mai_Nashaat ,

         

        The current version can not change the position of "Grand total", try to find a custom visual in appsource .

         

        Best regards,
        Lionel Chen

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

         

  • I could't find a visual that can be used.

    I thought I might solve this problem by creating a quick measure to calculatethe total and remove the grand total from the matrix

    I have customers and categories, each customer have sales for each category.

    Any hint how can I make his measure also if this applicable or not.

    thanks in advance

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support

    Hi Mai_Nashaat ,

     

    Is this what you want?

    14+9+1.25

    6+6+1

    8+3+0.375

    ...

    Please provide a sample data.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Mai_Nashaat's avatar
      Mai_Nashaat
      Helper II

      No actully, 14 is the summation of targets for this customer 6+8, inoice 9 is 3+6 and so the others