Adding Calculated Content in particular Dimension

[sarfaraz_sheikh]

Dear All,

I have one user requirement like below,

As of now the chart is looking like below :-

However I want my chart to appear like below..one more conversion field i want immijiate next to ISales_Closed_Final.

Calculation for Conversion ........

ATotal_Leads_Considered                        ISales_Closed_Final                                   Conversion

Amount=197457                                       Amount=177247                                 177247 / 197457 = 89.76

Count=28                                                  Count=25                                                  25/28 *100  =89.28

Is this possible in above pivot chart ....Because all the columns in Blue colour are the dimensions content ...at dimension level how i can calculate percentage between two fields ...

Is there any way if yes the solution would be much appreciable .... There is requirement like this from user...

Sarfaraz

[sarfaraz_sheikh]

kindly reply if solution is possible .............suggest any way to do it.

Sarfaraz

[Anonymous]

Given that the columns are the values of the Status_Description field, and there is no value 'Conversion' - you have to add it in the script, and calculate right there.

[sarfaraz_sheikh]

Dear Michael,

Your are right ....same is my concern ......I tried that but failed to add conversion field in that.

Kindly suggest me how i can add that field with calculation .......

sarfaraz

[sarfaraz_sheikh]

Dear @ hic / Michael,

Please reply on it .....stuck in the problem ........

Sarfaraz

[sarfaraz_sheikh]

Dear Community,

any clue to achive the above requirement .........I tried but failed any alternate way i can try

kindly help ..

Sarfaraz

[Anonymous]

I found time to try.  See expressions for Amount and Count.  I ddin't touch Leads, left it for you...

I had to add 'Conversion' value tio the Status_Description field, and the relevant data, I called it SumTotal, sumclosed (For Amount calculation) and LEAD_NO_Total, LEAD_NO_Closed (for the counts).
See the script., hope it helps.  Probably there are better solution, but I've spent more time on this than I intended to...