Getting pivot table average ignoring Zero values
Dear Experts,
Kindly look in to the attached excel sheet with pivot table. In this(pivot table-REB shut & down time), I need to calculate "average of T column" (of date entry sheet) in cell T113, ignoring zero values in T column.
Your solution to this is highly appreciated.
Regards
Anuruddha
I suggest using a helper column - if the shutdown hours > 0 then calculate the percent. Else put the null string "".
Aggregates such as Average ignore non-numeric data.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks