Hi,
I have a pivot table with multiple columns. In these columns there are numeric values and zeros.
I want to count how many numeric values there are? Does anyone know how to do this - problem is that my pivot table keeps counting zeros.
Hi,
I have a pivot table with multiple columns. In these columns there are numeric values and zeros.
I want to count how many numeric values there are? Does anyone know how to do this - problem is that my pivot table keeps counting zeros.
You can hide 0 with blank cell through PT option. Right click on PT and click on Pivot Table option->Layout and format->Format check mark on for empty cell show and don't enter anything in blank box the ok.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Hi Ankur,
thank you for your input. Much appreciated. So I can understand exactly your instructions, are you advising to replace my zeros with blank cells?
I'm thinking that you mean you have zeroes in your raw data (not your pivot table) and you don't want these counted?
use a countif formula look for values greater than 0 or if you also have negative look for not zero ("<>0")
=COUNTIF("PivotRange";">0")
Hi Kersplash,
yes, that is exactly it.
I would think then you need to change the zeroes to blanks in your raw data via a formula, because the pivot table will count each zero.
Formula:Please Login or Register to view this content.
Last edited by kersplash; 04-23-2018 at 02:08 AM. Reason: added formula
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks