Dashboard that shows customers that purchase core range

[anon90441911]

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

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.