Hi excel gurus,
I have a list of rejected orders in an excel. It has information such as rejection date, vendor, rejection type, etc.
One of the analysis I want to do with it is calculate the percentage of rejections vs the total orders.
The number of total orders is in another table, as the list is only of the rejected ones.
The only way I've managed to do that is to add 2 columns to the data source: one for the total of orders, and the other one with a COUNTIFS that considers up to 6 conditions, making the excel very slow as it's calculating all the time.
I've thought of adding only the first column, as it won't slow down not being a formula, and adding a calculated field to the pivot table, but I can't becaue I would need: Count of orders / Total orders, and the field "Count of orders" is not available to create a calculated field, as it's a Value field.
Can anyone think of a better way to do it?
Thank you very much
I have a list of rejected orders in an excel. It has information such as rejection date, vendor, rejection type, etc.
One of the analysis I want to do with it is calculate the percentage of rejections vs the total orders.
The number of total orders is in another table, as the list is only of the rejected ones.
The only way I've managed to do that is to add 2 columns to the data source: one for the total of orders, and the other one with a COUNTIFS that considers up to 6 conditions, making the excel very slow as it's calculating all the time.
I've thought of adding only the first column, as it won't slow down not being a formula, and adding a calculated field to the pivot table, but I can't becaue I would need: Count of orders / Total orders, and the field "Count of orders" is not available to create a calculated field, as it's a Value field.
Can anyone think of a better way to do it?
Thank you very much
