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
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.
Edited by: Malik Naeem on Jan 20, 2009 9:01 AM