I have a list and I want to produce a count of items (rows) in the list filtered by a value (lets say its fruit type) in one of the fields.
easy enough to create a view that shows this, choose your columns to display, check "count" in the totals option, filter by the one your intrested in and you are away.
Problem is i dont want it in that format. I want to take the actual number ( e.g. how many rows had lemon as a fruit type, answer =4 ) and show that on another page, as a kind of dashboard number ( e.g. how many orders for lemons have we had)
This seems like such a simple thing to do, but 2 hours of playing suggest otherwise. Of course it could just be me being thick.
Any clues very greatly appreciated