2 Replies Latest reply on Sep 30, 2016 9:35 PM by shiva chary

# Percentage of items in a dimension - Please help , iam not able to do the calculation

I have total 5 elements in a Dimension : from thecolumn :  STATUS ( Attached excel)

 ANOB Started Offer declined Company No Interest Pending Offers

i need the following claculation :

Accept % = (ANOB+Started)/(ANOB+Started+Offer declined)

sample output in excel : I need this to be implemented in Tableau as below.

 Overall AP Europe GCG ISA JP LA MEA NA WW Aug'16 Jul'16 Aug'16 Jul'16 Aug'16 Jul'16 Aug'16 Jul'16 Aug'16 Jul'16 Aug'16 Jul'16 Aug'16 Jul'16 Aug'16 Jul'16 Aug'16 Jul'16 Started 209 249 290 737 253 427 1718 1720 57 33 272 385 45 75 94 386 2938 4012 ANOB 165 36 682 321 96 6 1875 727 13 11 201 5 81 18 478 116 3591 1240 Offer   Declined 17 12 95 112 9 24 173 230 2 6 26 30 2 2 48 42 372 458 Company No   Interest 6 11 17 11 1 11 51 139 0 0 4 5 2 1 6 8 87 186 Pending   Offers 2 0 28 8 1 1 362 95 4 2 4 0 7 2 83 5 491 113 Accept Rate 96% 96% 91% 90% 97% 95% 95% 91% 97% 88% 95% 93% 98% 98% 92% 92% 95% 92% Total Offered 399 308 1112 1189 360 469 4179 2911 76 52 507 425 137 98 709 557 7479 6009
• ###### 1. Re: Percentage of items in a dimension - Please help , iam not able to do the calculation

Hi Shiva,

The following calculation should return the percentage you are looking for.  Let me know if you have any questions.

Regards,

Ivan

SUM(IF [Status] = 'ANOB' or [Status] = 'Started' THEN 1 ELSE 0 END)/

SUM(IF [Status] = 'ANOB' or [Status] = 'Started'  or [Status] = 'Offer Declined' THEN 1 ELSE 0 END)

• ###### 2. Re: Percentage of items in a dimension - Please help , iam not able to do the calculation

Hi IVAN , Thank you so much  for your help, It worked ,

below is the output i got it in Tableau.