2

I have a new request that I have to fulfill by Monday. So I have been requested to get the total item count of list items in a share Point list which also has a condition to it, which is Items visible only to the person who created the item.

I also have a drop down which has two columns Available and consumed, I wanna get the total count of list items of which are consumed and which are available in two different columns one for available and one for consumed.

So I need three columns which are:

  • Total Count, Available Count, Consumed Count.

If you guys know how to do this, Please help me out. Thank You.

  • Do you need it in the form using some jquery or in list view ? question is not much clear – Suresh Bolineni Apr 20 '18 at 5:17
  • i need it in a list view. There will be three columns which Total count, Available Count and Consumed Count. I wanna populate these columns with count values in list view. – jayant khushalani Apr 20 '18 at 5:24
10

No need to create a three column to achieve your goal, Also the Calculated Column and SharePoint Designer does not help in this context!


The simple OOTB workaround is

  • Create one view with the following settings

    • To filter with Created By User

enter image description here

  • To Group By with the Status (Available/Consumed)

enter image description here

  • To get the count for each status and the total count

enter image description here

[OutPut]

enter image description here

  • I see that you have provided a very detailed answer and it seems a really easy solution. I just wanted to ask you only on the filter it shows the count for status items right. I also wanted to know the count of total list items if the above condition which is Created by [Me] is applied. – jayant khushalani Apr 20 '18 at 10:51
  • @jayantkhushalani Yes, it's right Please don't forget to upvote and mark the answer as accepted in case it helped you :) also don't hesitate to ask if you have any other related question! – Mohamed El-Qassas MVP Apr 20 '18 at 12:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.