Vertically Calculate Count, Total in sharepoint and store in variable for future use

How to Calculate total vertically in sharepoint.
i.e share offer a total with colunm A + Colunm B
but my requirement is to calculate Total in respect of Rows
i.e SUM ( Row-1-ColunmA + Row -2-Colunm A) for get the Desired Result. i need this colunm for Calculation please any body help

   
wateenitdevAsked:
Who is Participating?
 
thmanConnect With a Mentor Commented:
You need to create a page and insert a DataFormWebPart. In that web part, you can use XSLT to do the calculation. To find an example, you can use SharePoint's HelpDesk template to create a site and use SharePOint Designer to open the default.aspx page which has codes for the KPI indicator on the page. It shows you how to get the sum for each issue status and then calculate a percentage for each issue status.
Or you can use SQl Server Reporting Service to generate reports. This approach is bit long path to go if you are not familiar how SharePoint stores data.
 
0
 
dp_expertConnect With a Mentor Commented:
Or you could create a workflow with SharePoint designer (now it is a free tool) that would calculate after each item change and store the calculation result in some other list and then insert the calculation result in a selected columns of selected item
0
 
thmanCommented:
It is not easy to do that in SharePoint Designer workflow - the functionalities are very limited. It is possible to do it in event handler which is programmed in Visual Studio.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.