Totals row in a table chart

Forums Dynamic Forms for SharePoint Totals row in a table chart

Tagged: ,

This topic contains 5 replies, has 2 voices, and was last updated by  Phil Grant 1 day, 2 hours ago.

  • Author
    Posts
  • #21729

    Phil Grant
    Participant

    Alexander,
    Sorry but I just don’t understand the option “Show totals row for table chart” I’ve selected this but I get an error at the bottom of the chart.
    Most columns in my table are strings with one that’s a number I wish to total, this is Col. 12, how can I show a total of these values?

    I guess I’m missing something obvious or the option isn’t what I think it is.

    Regards,
    Phil

  • #21761

    Alexander Bautz
    Keymaster

    Hi,
    I’m not sure which error you get, but you must specify the first column in the chart as Data Type String and not as Number.

    Alexander

  • #21768

    Phil Grant
    Participant

    Ok, the first column is set as a number (Id) so I can change that but which rows are totalled, can it be specified?

  • #21774

    Alexander Bautz
    Keymaster

    Columns with data type Number is totaled.

    Alexander

  • #21780

    Phil Grant
    Participant

    OK, Makes sense I suppose, I’ll give it a try.

    Thanks

  • #21803

    Phil Grant
    Participant

    Alexander,
    That worked.

    Sorry, I just realised I posted in the wrong forum, should have been in SPJS charts.

    Is there any way to format the Totals row, I’ve looked a “inspect element” but cannot see how to sort it.

You must be logged in to reply to this topic.