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.