Skip to Content
0
Former Member
Jan 20, 2009 at 08:01 AM

Count the number of customer in query designer

24 Views

Dear Friends,

I am trying to create a query where we have two key figures.

( Division ) (Total Customer) (Total Customer who purchase)

10 10 5

20 20 15

This means i need two figures one is total number of customer against

each division irrespect of sales either they purchase somthing or not means read from

master data.

and second figure i need total number of customer who purchase

from us by eash division.

second KF is achived by creating a New Formula and put 1 in detail view and

in aggregation tab i select total option and in ref. char. i choose division.

now i am getting right number of customer who purchased from us.

for KF one i dont know how can we read from master data for customer count.

i know there is a option for characterstics in advance properties choose from

transaction data or from master data but i am unable to build logic for counting using

these advance features.

any help higly appricated.

Regards,

Malik

Edited by: Malik Naeem on Jan 20, 2009 9:01 AM