Percentage by row total in Pivot

[#1]

Hi,

In a pivot table, I want to do the following: I want to show the percentage of orders not affected by a certain code for being late, on the total number of orders from a carrier. So the table I'm trying to built is the third one, the first two are just to make my problem clear.

In the pivot table, I have the carrier vertical, and the reason code vertical.

For the cell of the intersection of "Archbold" and "2", I want the table to make the calculation (507-2)/507 = 99,6%. My formula at the moment is: (count([orders])-count([reason code late order]))/count([orders]) As a result, I get (2-2)/2 = 0%.

Basically the only number I get correct at the moment are my totals. Can anybody tell me how I should write my formula?

Thanks!

[#2 · Accepted solution]

I think you need something like this:

1-count([reason code late order])/count(total <R> orders)

R is name of field with your "reason" dimension.

try and let me know.

reg

D