Forum Discussion

Anantha's avatar
Anantha
Frequent Visitor
10 years ago

Conditionally display columns based on options in report filters

I want to select certain options based on report filters. If the column doesn't have any value, is there any way to not display it
Anantha's avatar
Anantha
Frequent Visitor
10 years ago

Let's say I have 2  report fileter one for country (India, US, China) and one for Cities(Delhi, Mumbai, nyc, Shangai)

 

and my data in excel is structured as follows

 

Country    City        Comments   country                            Comments city

India       overall     econmoy doing good

India       Delhi                                                                Delhi is the capital

US         overall     US is the world's richest economy

US        nyc                                                                     major business hub

 

 

Now, if I select India in my country filter and don't select any city, I want only the comments from the column 'Comments country' i.e (economy doing good ) to be displayed

If I choose India and delhi, I want the comments from column 'Comments  CIty' (Delhi is the capital) to be displayed

However, I don't want the "economy doing good" to be shown 

Is there any way to do this?

BrentA's avatar
BrentA
Icon for Advocate II rankAdvocate II
10 years ago

I would build a calculated column to filter on that conbines the columns and use that as the filter such as;

Location = CONCATENATE([Country]," " && [City])

Then add that as the slicer.

 

Although I would have thought that when you select Delhi it would only bring back that row anyway.