Displaying total against the grouped field

Forums vLooup for SharePoint Displaying total against the grouped field

This topic contains 3 replies, has 2 voices, and was last updated by  Gerard Graham 2 years, 11 months ago.

  • Author
    Posts
  • #8460

    Gerard Graham
    Participant

    Hi there

    I have a child list (grandchild actually) holding staff and days allocated against outputs for a project. I’d like to display the unique staff names and the total of days allocated across all the outputs. I’ve got this working to an extend by grouping the Days field under the Staff name with the days total sitting under each name. (see attached)

    Is it possible to display the total beside the name? Is there another way than using the Group By option?

    Thanks

    Gerry

    Attachments:
  • #8462

    Gerard Graham
    Participant

    Also meant to ask will it ever be possible to allow a multi-level group by option e.g. by staff and by output in the example above.

  • #8481

    Alexander Bautz
    Keymaster

    Hi,
    Are there more than one “line” in the list for each employee?

    I’ll consider adding grouping in multiple levels, but this is a bit tricky. You might have to use a custom function to create the output you like. If you have the necessary JavaScript knowledge, you might be able to use the data object returned from vLookup in a custom function? – look here for information: http://spjsblog.com/vlookup-for-sharepoint/vlookup-user-manual/#Accessing_the_vLookup_data_object

    Alexander

  • #8484

    Gerard Graham
    Participant

    Hi there

    Yes, there are multiple lines per employee in the list. I’d be filtering for a single project and summing employee hours for all outputs for that project.

    As for Javascript knowledge – nil.

    I can pull a spreadsheet for the list and use a pivot table to get the information I need so I do have a way, but in the vlookup would be better.

    Thanks

    Gerry

You must be logged in to reply to this topic.