Zero and missing values in pivot

[#1]

Hi!

I have a table that is connected to another one.

When I create a pivot table for the first table I have something like this:

Month_Date	Dec				-	-	-	-
BG_bench	Bench USD	Budget	%	Overuse	Bench USD	Budget	%	Overuse
BG1	62,010	14456	-329%	-47554	-	-	-	-
BG2	0	2886	0%	ok	-	-	-	-
BG3	0	2886	0%	ok	-	-	-	-
BG4	0	2886	0%	ok	-	-	-	-
BG5	0	2886	0%	ok	-	-	-	-
BG6	0	2886	0%	ok	-	-	-	-
BG7	0	2886	0%	ok	-	-	-	-
-	-	-	-	-	0	0	-	ok

I mean I dont need this "-" values, cause it looks kinda ugly.  I thing the reason is that my current table is connected to the other one.

I ticked "Suppress Zero values" and Suppress Missing, but it's still the same.

Any ideas why it can be like this?

[robert_mika]

I assume those are not 0 but NULL.

Try to use ISNULL in your load or IF(TRIM(LEN(yourfield))="".....

[b_garside]

The quickest solution is to try this... remove the hyphen shown below under the 'Presentation' Tab.

[buzzy996]

are u applied on all ur dimensions in ur chart?,the same setting u mentioned this thread i.e "Suppress Zero values"!