# Count based on conditions without showing data

**URL:** <https://community.spicecrm.io/t/count-based-on-conditions-without-showing-data/158>\
**Category:** Uncategorized\
**Created:** [July 15, 2017, 2:44pm UTC](https://community.spicecrm.io/t/count-based-on-conditions-without-showing-data/158 "2017-07-15T14:44:01Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sravani.tedla](https://avatars.discourse-cdn.com/v4/letter/s/aca169/32.png) [@sravani.tedla](https://community.spicecrm.io/u/sravani.tedla)\
**Post date:** [July 15, 2017, 2:44pm UTC](https://community.spicecrm.io/t/count-based-on-conditions-without-showing-data/158/1 "2017-07-15T14:44:01Z")

</div>

Hi All,

Could you please let me know how to create count of particular stage / something without giving data. Like as per the below screenshot

 ![](https://canada1.discourse-cdn.com/flex030/uploads/spicecrm/original/1X/ea9b3e9a530f7570bfff24528b92c426c9f4d293.png)

It is giving Sales Stage too, If i remove Sales stage from manipulate i m not able to find that filed in manipulate and present it in grouped view based on sales stage.

I only need count of records without printing any data

Could you please guide me a way.

---

<div class="post-metadata">

**Author:** ![maretval](https://avatars.discourse-cdn.com/v4/letter/m/b38774/32.png) [@maretval](https://community.spicecrm.io/u/maretval)\
**Post date:** [July 15, 2017, 3:03pm UTC](https://community.spicecrm.io/t/count-based-on-conditions-without-showing-data/158/2 "2017-07-15T15:03:52Z")

</div>

Sravani,  
you just need to group by sales stage and count IDs in manipulate.

 ![](https://canada1.discourse-cdn.com/flex030/uploads/spicecrm/original/1X/aacff41e052bac93e8028f38109a0e89cd2407f0.PNG)

You also may want to check KReporter Youtube Channel [https://www.youtube.com/results?search\_query=kreporter](https://www.youtube.com/results?search_query=kreporter) to learn how to build reports.

Val
