I have a pivot table which displays the number of transactions (Successful, Bad, Failed, #value) by day of the month. I've created a column with a calculated item field to get the percent of successful transactions each day. The calculated field adds success and bad transactions and divides the success transactions count by the success plus bad transactions count. The calculated item field is working good, except for the grand total. In the grand total row it is adding all the percents from each row and giving me a total percent. So, if I have 10 rows with a percent of 89%, the grand total is displaying 890%, which makes sense since it is the grand total row.
How can I get the cell in the grand total row/calculated item column to use the same calculated item formula as the rest of the rows do and calculate the percent based on the other numbers on the grand total row?
Bookmarks