How to create a sales report that only displays 0-sales customers

[#1]

Hi!

I am trying to duplicate our sales report and to create the non-sales report, i.e. a report that only displys the customers with zero or less.. in sales for the specified period and SBU.

My report looks like this currently

SBU#       CustID       CustName       Sales(expression Sum(Sales) )

In the current one we have not selected show all values so all null or zeros are not displayed

No I try to create the opposite and I have tried to set the dimension limitations to show only values that are zero or less.

However in doing this I cannot get it to work if I only want to see this report for SBU# 10 (which I can choose in a listbox)

I would attach screenshots but it is all in swedish so probably won't help.

Thanks for any pointers in this case,

Erik

[swuehl]

Assuming a single expression:

=Sum({<CustID = {"=sum(Sales)<=0"} >}Sales)

and disable 'suppress zero values' on presentation tab.

[#3]

Thanks, I still cannot get it to work as my table result gives me all other

SBU which also have 0 or less in sales. Attached a screenshot of the result

and the current selection.

I am doing something wrong obviously (using your exact code for my

expression)

Sum({<Filialnr = {"=sum(Faktbel)<=0"}>}Faktbel)

[swuehl]

You want your current selection considered in the set expression?

You can do this using the set operator *

Sum({<Filialnr = p() * {"=sum(Faktbel)<=0"}>} Faktbel)

[#5]

Exactly, the selection I do in my listbox for the report should (and does

when I use the alternative report where I display customers with sales and

then just the straight expression Sum(Faktbel) (i.e. my swedish sales).

I think I am doing something else wrong as I still cannot get it right the

way I want it and I am too unskilled in QV. Thanks for your help!

[swuehl]

Do you have more than one expression? (The set expression needs to be applied to all expressions)

If not, could you upload  a small sample? (you don't need to upload real data, just some mock up data will do, if the structure of your data is comparable to your real application)

[#7]

Only one expression but I think the problem I have is that I have not setup

the link between the sales/transactional table and the customer table

properly in this report. I.e. I want to do exactly this

1. Take all customers in my customers table based on the selected SBU#

2. Use this to compute sales from the transactional table for a) the period

I select(dates) b) the customer IDs from the customer table c) purge all

customerid with sales less than or equal to 0

I believe my linkage is poor here and I need to look into this

unfort I cannot extract a small portion of data or even mockup but I think

the problem lies on what I mention above now when I have tried with your

help