# Dashboard that shows customers that purchase core range **URL:** \ **Category:** Ask the Community\ **Created:** [April 4, 2018, 6:31am UTC](https://pug.phocassoftware.com/t/dashboard-that-shows-customers-that-purchase-core-range/553 "2018-04-04T06:31:09Z")\ **Posts on this page:** 1\ **Showing post:** 7
**Author:** ![anon90441911](https://avatars.discourse-cdn.com/v4/letter/a/a4c791/32.png) [@anon90441911](https://pug.phocassoftware.com/u/anon90441911)\ **Post date:** [December 4, 2018, 7:39am UTC](https://pug.phocassoftware.com/t/dashboard-that-shows-customers-that-purchase-core-range/553/7 "2018-12-04T07:39:20Z")
Hi Patrick, To identify Core products, it will be best to do it at Source Data that you sync to Phocas (can be excel) and then add it as a subdimension of your Product. It will then gives you the flexibliy of maintaining the Core products list. Then you can focus on Core to get product list and continue to use standard Phocas measures. For the measure, you can then use the Case When (similar to If logic in Excel) in the following post : > [@Custom mode - calculated variances returning a number](https://pug.phocassoftware.com/t/custom-mode-calculated-variances-returning-a-number/802): > > Hi - have a dashboard in custom mode with a number of calculated fields. Stock committment rate % (calculated) Stock committment target % (from upload) Stock committment variance to target %(calculated) I’m trying to add some logic in that says… If stock committment variance to target is greater then 10%, then have another column that returns “Discount by 5%” or even “5” This repeated… so if stock committment variance to target is greater then 20%, then returns “discount by 10%” or even “1… Eg: If sales \>0, then ! else - to give you an indicator of those customer that have or have not purchase the core products. --- _[View the full topic](https://pug.phocassoftware.com/t/dashboard-that-shows-customers-that-purchase-core-range/553)._