Show Table Totals at the Bottom of Columns

7 Comentários

  • Chris Bulin
    Ações de comentário Permalink

    Mine shows up at the bottom, but I have noticed that the way they phrase their sums and the way I think about them is different. If I want to sum a column, they consider that a sum of the rows in that column. So for example in the table below, the sum was on the row rather than the column and it showed at the bottom.

    0
  • Gentry Geissler
    Ações de comentário Permalink

    Thanks for the question, Graeme. In that menu for Result Manipulation > Totals, look at the bottom for Inverse totals position. This will make the sums switch from top to bottom.

     

    0
  • Graeme Carmichael
    Ações de comentário Permalink

    Gentry

    Yes I have been flipping that little check box but it does nothing for me.

     

    Counts appear at the bottom but do not move when he inverse is changed.

    Chris- yes the terminology caught me as well.

    0
  • Gentry Geissler
    Ações de comentário Permalink

    Graeme,

    You have a manual sort on the Tickets column, and this will over-ride the total settings. Click the column header again until the triangle goes away and that should fix it.

    0
  • Graeme Carmichael
    Ações de comentário Permalink

    Gentry

    That is very well spotted. Thank you, that has resolved it,

    However, from a design view, that makes no sense whatsoever. The sort option should not apply to the total. It should only apply to the rows. The total position should be only determined by the result manipulation. 

    0
  • Graeme Carmichael
    Ações de comentário Permalink

    Gentry

    So I am going to call that a bug. 

    It is only by chance that a column sorted by value would have the the total exactly at the top or bottom. For example, if there were negative and positive values, the sum could appear in the middle.

    Similarly, if you use another aggregation, such as average, you may see this:

     

    In the above example, the average appears in the middle of the report. This is not very useful.

    Can you confirm that this is a known issue?

     

    0
  • Travis Rider
    Ações de comentário Permalink

    Hey Graeme,

    Thanks for the detailed replication steps and screenshot! I'll get this into a ticket so we can investigate further.

    0

Por favor, entrar para comentar.

Powered by Zendesk