Forum Discussion

ZVV's avatar
ZVV
Frequent Visitor
8 years ago

Add Total row for table (column is not summarized)

Hi   I have a number column in Table report. I don't need to Sum() this column (marked as "Don't summarize"), but I still want to see Total sum for this column.   I have several lines for each d...
v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
8 years ago

ZVV,

 

You could use a  table visual to display data in your table, mark as Sum, and then turn on Total.

 

Regards,

Charlie Liao

ZVV's avatar
ZVV
Frequent Visitor
8 years ago

I mentioned in the question that I can't mark "Sum" - it must be marker as "Don't summarize".

In this case Grans Totals do not appear regardless of "Totals" setting.

  • v-caliao-msft's avatar
    v-caliao-msft
    Microsoft Employee
    8 years ago

    ZVV,

     

    If that is the case, I am afraid there is no such a option to show total row in your table visual. Thank you for your understanding.

     

    By the way, why cannot mark it as "SUM"?

     

    Regards,

    Charlie Liao

    • ZVV's avatar
      ZVV
      Frequent Visitor
      8 years ago

      Thanks, Charlie

       

      Regarding "why" - again, I mentioned it in my question (with some figure corrections):

      >> For example I have lines with 3, 5 & -8 for today. If I mark the column as "Sum" - I'll have just one line with 0.

      >> But I need to see all three lines and have Report Total at the same time.

       

      Currently as a workaround I've added a line ID field to report and made the column as narrow as possible (so it's almost invisible) but I don't like this solution.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        For the ID field, you can right click on the ID column in the table view and mark "Hide in report view" --> This will not show in the report view.