1

I am using Data Form Web Part in SharePoint Designer 2010 (or XSLT Web Part would also work):

I have a table like below:

ColumnA         ColumnB         Status

Project1        Task1.1         Completed

Project1        Task1.2         Pending

Project1        Task1.3         Completed

Project2        Task2.1         Completed

Project3        Task3.1         Completed

Project3        Task3.2         Completed

Project3        Task3.3         Completed

Project3        Task3.4         Pending

Project3        Task3.5         Pending

What I want to achieve is:

Project1        66.67 ((Completed Task / Total Task) * 100)

Project2        100

Project3        60
Improve this question
1
  • Guys, No answers? Commented Sep 23, 2013 at 12:43

1 Answer 1

Reset to default
1

I don't think this can be done with the SPD 2010 Visual Designer, but could probably be done by hand coding some custom xslt. In my opinion however , your best bet would be to get the data to the browser using csom or rest or spservices and render it there using javascript (maybe jsrender templates). I think you need either custom XSLT or custom javascript to do this.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.