Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a Straight table with multiple fields/columns.I have a requirement to hide a column Post_Address when Post_Address=NA for a particular ID
and another column Child_Num when Child_Num=0 for list of ID's.
already tried with the below
if(Post_Address<>'NA',Post_Address)
SubStringCount(Concat(ID,'|'),1002)>>0
If(IsNull(POSTAL_CD),0,1) ---->This is not applicable
Please suggest if anyone have any idea?
Thanks in advance.
Try this. This sounds like it solves your problem.
Can you post an example document that demonstrates the problem?
I can't post the document Gysbert.
I have a straight table which is having 6 fields in dimension. ID,Post_Address,Child_Num,Parent_Num and so on.
For a particular ID, Post_Address value=NA likewise Child_Num=0 for list of ID's also.
My requirement is For those ID's having Post_Address=NA, we should hide the Post_Address column.but it should display for other ID's same for Child_Num also.
Thanks.
Hi gtripathy,
You can do that by making every dimension that complies with that specific condition to null and then suppress null values.
For example, if(Post_Address<>'NA',Post_Address,null()) and extend that for every expression.
Regards.
Hi Nikos,
Tried that infact hides other dimensions in the chart.
Hi gtripathy,
I dont think there is a way to hide only a specific colunm on a chart as per your requirement.
You can try calculated dimension but it will still have the same result.
Regards.
If I'm understanding you correctly, you want to hide the column Post_Address only for rows in a straight table that have a value of "N/A"?
Showing blank doesnt meet your criteria, correct?
Does this table show several IDs or only for looking at one particular ID?
In other words, could the Post_Address column have "N/A" values and non-"N/A" values? If it shows both types simultaneously, then you cannot hide the column for just specific rows. You will either need to blank the value for rows meeting your "N/A" criteria or hide the column for all rows.
Hi Matthew Riedl,
I want to hide the column Post_Address column if it is equal to NA.This straight table actually shows ID's based on the SalesForce.
What it mean is e.g- For Salesforce AI, There ll be a Detail straight table shows ID,Post_Address,Child_Num and all based on that SalesForce.
So Suppose for SalesForce AG, straight table shows all Post_Address,Child_Num,Parent_Num for ID 1005,1006.
If the Post_Address values are NA for both the ID's,i want to hide the column.
Thanks.
Try this. This sounds like it solves your problem.
Thanks Matthew.It worked.But if i have two fields to hide like NA and 0.
if(only(Post_Address)='NA' or 0,0,1) i tried this but it didn't work out.
Thanks a lot again..:)