How can i "auto hide the" values/names on X row when there is no actual value in the table this is based on?


Capture.PNG

I have made an dynamic table but due to the values it's not possible to have an proper chart showing the correct values due to the commodities changing places due to **** value and sort by function. I wish only to show the commodities that have an actual value, the rest must not be shown
I wish to show the values for the commodities on each trade "SAM / EUR / FE" etc.

Capture1.PNG