Hi All
I use Table builder to create a table in excel. However there are some fields are only used for formula. Is possible we can hide those fields?
I tried Condition Hide way in Table builder, but it seems does not work.
This is the example what I did, but the "Hide/Show" does not spread.
Does anyone have ides about this issue?
Thank you very much!
Best Regards,
Jack
Hi zhengming chen,
the article below should help you.
No, I don't believe it is possible to conditionally hide NL("table") columns, because the data is inserted into Excel in a method dissimilar from the replication you're accustomed to in NL("rows") and NL("columns")
This is demonstrated from the fact that your NL("table" is in column D which is in the same column as your Filter Values but the Filter Values are not duplicated across the entire report.
You could build a traditional Data Dump. But then it makes it more challenging to summarize the data in Tables / Pivot Tables, especially given the recent changes to the product.
