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(IsNull(POSTAL_CD),0,1) ---->This is not applicable
Please suggest if anyone have any idea?
Thanks in advance.
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.
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.
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.
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 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..:)