Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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 ?
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.
I dont know how do i Work out to do that.
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.
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
The reason is I want to have a cross tab the month/year based on the service type.
Hi,
It is not doing anything.
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 ?
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(-).
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?