Hello,
I am using two data source in a template with same structure as you can see, I have hidden the lines from 57-60. because It is header of another query.
Now the problem is I am using Plant as a prompt and you can see I have selected GLCL Plant as of now. This plant contains three work center you can see.
1. Chirala Process Line 2
2. Chirala Process Line 3
3. Chirala Process Line 4

Now the second scenario is when I am selecting another plant as a prompt Like GLAP.
It only contains only one work center i.e. Anarpathi Line1. Because of only one workcenter
it left two cells blank as you can see 56 and 57.
So is there any conditional formatting or rules which we can use through prompt variable for hiding this cells.
or any kind of suggestion for my problem ??
I have a same question related to this, Is there any condition like Let assume for Cell 10-50 in these columns whichever column is blank should hidden automatically.
Thanks in advance.
