Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

List - Create a view that shows totals

  Asked By: Willis    Date: Feb 09    Category: Sharepoint    Views: 3309

You can definately tell I am a newbie at sharepoint. I know what I
want to do but I don't have the experience to get it done. I have a
list that has a bunch of columms. One of them is called "Sold". It
has a check box option of yes or no. Then I have one called "Price".
I have a view that filters by "Sold" being yes and then sums "price"
to show how much we have sold.

That is exaclty what I want as far as returned data but I would like
to make it just show a total and not the columns. I am going to add
the view to the front page so we can keep a running total of what has
been sold. It is for a fund raiser for United Way.



1 Answer Found

Answer #1    Answered By: Matt Prince     Answered On: Feb 09

OK I am still struggling on this and I am sure I am making it a lot
harder then it should be.

If I copy my data  into excel and add a new colum and have a cell that
has this formula I get exactly what I want.


The columns  in sharepoint  that it is referring to is:


I don't know how to do something like this in sharepoint. Basically I
want a list  view or something that i can put on the home page  that
calculates a forumla like above that just shows  a running total  of the
funds raised by all sold items.

Didn't find what you were looking for? Find more on List - Create a view that shows totals Or get search suggestion and latest updates.