Show performance in pivot table

[Anonymous]

Hello,

I have to show the performance of successful offers made up by the sales department: I'd like to show, for each customer, the number of successful and unsuccessful offers and their incidence on the total of offers quoted to him.

I use a pivot table with the customer's name and the type of offer (successful and unsuccessful) in dimension, and the Count (Distinct (OfferID)) in expression, but I'm not able to calculate the percentage incidence of each one (successful and unsuccessful) on the total of each customer.

Could anybody help me, please?

Thanks.

Nick.

[#2 · Accepted solution]

Hi,

try filtering for succesful and unsuccesful.

Expression for succesful could be:

Count (Distinct {$<[type of offer] = {'Succesful'}>} (OfferID)) / Count (Distinct (OfferID))

and in Number Properties check the Setting (Integer) and then check "Show in percent %"

Hope it helps

regards

Giampiero

[Anonymous]

Yea! It works properly!

Thank you very much.

Nick.