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.

[sdmech81]

Hi,

There is no direct option for this.

If you want that it should not be visible to any one,then replace those values show them as you wish.

[Anonymous]

I dont know how do i Work out to do that.

[ramasaisaksoft]

1) I hope u r asking Pivot

Right click on Pivot table Properties-->presentation tab--> select the first field (Group Name)-->Check the option for

Allow Pivoting.

2) If you want to hide only for one record then write a condition in Dimension

if(groupName='specify the text you have',' ',GroupName)

and do Suppress when value is Null option also so that it will remove Null Values.

[anushree1]

HI Vamsi,

Can you explain why you would want to bring the service type column into pivot so that we can think of a alternative method to achieve the requirement

[Anonymous]

The reason is I want to have a cross tab the month/year based on the service type.

[Anonymous]

Hi,

It is not doing anything.

[vishsaggi · Accepted solution]

What is that you want to display in Service Type column? You want blank in that column? If yes, just use

= If(Len(Trim(Service_Type)) > 0, '', Service_Type)

Else, please let us know what exactly you want your output to be ?

[Anonymous]

All I want is not to display the comments in the service type "user said they will tell their friends about the service"

Probably just a dash(-).

[vishsaggi]

Only that comment or the whole comment field? Can you share a sample to work on, it takes time to create a sample at our end?