how to hide the some of the contents in the table?

[Anonymous]

Hi ,

I have table with column name 'group name 'under that feedback -comments.

And Service type.as one more column we have contents for that comments.

(How shall I hide those comments)

any helps pls.

Here is the fie.

[Anonymous]

yes i did try that if expression but cant see no change.

[vishsaggi]

And why you cant upload here? Did you login to your account? And using Advanced editor cant you upload the file ? Just wondering to know...

[Anonymous]

There you go.

Didnt see the advanced editor earlier.

[Anonymous]

The contents of the comments in the service type change continuosly.

I dont know how you would avoid this at the pivot table to not to show.

[vishsaggi]

This is what i can see in your file.

group name	Service Type	date	10/09/2016	11/09/2016	12/09/2016	13/09/2016	14/09/2016
comments	serice is not bad I will inform		1	-	-	-	-
emotional	puberty		-	-	-	1	-
feedback	3		-	1	-	-	-
phsycial	healthy eating		-	-	1	-	-
sexual	low mood		-	-	-	-	1

So you dont want to see the value for Comments Group? Does below work ?

group name	Service Type	date	10/09/2016	11/09/2016	12/09/2016	13/09/2016	14/09/2016
comments			1	-	-	-	-
emotional	puberty		-	-	-	1	-
feedback	3		-	1	-	-	-
phsycial	healthy eating		-	-	1	-	-
sexual	low mood		-	-	-	-	1

If Yes, then in your dimensions use this expression for Service Type.

= IF([Group name] = 'comments' AND Len(Trim([Service Type])) >0, '', [Service Type])

[Anonymous]

Probably a hyphen will be good in the  service type for the comments.

I have used the same expression but i am getting all servicetype

[vishsaggi]

Can you tell me what is that you dont want to see in service type and in my expression just use '-' instead of '' ?

[Anonymous]

I have used the same expression as above.

[vishsaggi]

Did you try this ? Let me know

= IF(Len(Trim([Service Type])) >0, '-', [Service Type])

[Anonymous]

It is working but it is replacing the whole column values with hypen.