Skip to Content

Conditional Formatting with Prompt Variable (Analysis for Office)


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.

scn2.png (27.3 kB)
scn1.png (24.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • May 22, 2018 at 09:26 AM


    You can try this:

    Create multiprovider on two data sources and create single query on multiprovider then it is very simple to get desired results.



    Add comment
    10|10000 characters needed characters exceeded