Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
The expression which is not working as I am trying to find overall % of each customer, and the expression is as followed and the Tras_No has some duplicate records so when I use TOTAL with Distinct the expression become incorrect, could you please any one suggest workaround for this.
=Count(Distinct(Trs_No))/Count(TOTAL(Distinct(Trans_No)))
Regards
Chriss
try this
=Count(Distinct(Trs_No))/Count(TOTAL Distinct(Trans_No))
also try this
=Count(Distinct Trs_No)/Count(TOTAL Distinct Trans_No)
Total for each customer would need to have something like this:
=Count(Distinct(Trs_No))/Count(TOTAL <Customer> (Distinct(Trans_No)))
Alternatively, I think you can also use the Aggr() function like this:
=Count(Distinct(Trs_No))/Aggr(Count((Distinct(Trans_No))), Customer)
Jonathan