1 of 1 people found this helpful
You might try a calc like:
IF WINDOW_SUM(SUM([Qty])) == 0 THEN 0 ELSE 1 END
(set the Table calc to compute Table Down)
This will determine if the total for the column is 0. If so, the result is 0 otherwise it's 1. You can place that field on filters and keep where it's at least 1. That will remove the column (though it will still show if you have any totals enabled).
Thanks for the response. Appreciate it, you always come forward with some innovative solutions to help!
I tried the scenario, but it is not working as expected, so I'm thinking of taking care of this in the back-end logic.
I raised another question regarding export to CSV with Titles in the below thread.
Could you please let me know, if this is possible in Tableau?