Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all, please I need your help, how as I can to count customer total for centers, to calculate concretion for mark, I need, count customers for mark total / customer total for center Ex.
Center Mark-1 Mark-2 Mark-3
AAAAA 100/1000 150/1000 225/1000
then 1000 is total customers
Thanks for your help
I don't really understand your table but wouldn't you be able to use
=count(distinct CustomerID)
if you have a field for CustomerID. Then you would get the count for AAAAA Center per Mark-1,Mark-2 and Mark-3 Then by displaying totals you would get the total customers for AAAAAA.
Hope this makes any sense.
/F
Thanks, but I need is calculate a total the customer for center and to use it in the denominator of each calculate for mark. The calculates of the mark it is different in each column (this subject to the mark), but the count total customers is unique, In the expression write to count the total of the mark,
=sum( ( (Aggr(Count(DISTINCT Mark&date), ClienteID,Mark,month))>=0 ) * -1 ) / ???
but I don't know as counting the total of clients without it considers the mark.
I think you should be able to use Count(distinct total ClienteID) then.
as denominator in your expression
thanks again, it works but gives the total of all the centers, I need that same but separate for the centers AAA, BBB, CCC
Ex.
Center Mark-1 Mark-2 Mark-3
AAAA 100/100 125/100 200/100
BBB 50/80 30/80 70/80
CCC 125/300 200/300 170/300
Thanks
Hello,
Why don't you use a Pivot Table with Center and Marks as Dimensions and Count(distinct total ClienteID) as Expression? Whould that help? Do you need all ersults in just one expression?
Regards.
Hello and thanks for answer
Yes, it is a pivote table, where the Centers and the marks are dimensions, and the expression should take both totals, to obtain the concretion.
Hi .. Do you try ....
Count
(Distinct IDClient) & '/' &Count(Distinct Total <Center> IDClient) ??