Deriving the report based on the country selected

[ak00428233]

Hi All,

Could you please suggest me the expression in such a way that when i select a country only that report country should be visible irrespective of the other countries accessed.

Ex:Below is the screenshot from the report where china is selected but i am able to view the other reports accessed.So could you please suggest me the expression so that i can get only cash flow Budget china,Master Budget China,Operating Budget China.

Thanks in advance.

Regards,

Anu.

[ak00428233]

Hi Vishwarath,

It worked by keeping the same expression =IF(WildMatch(Report, '*'&GetFieldSelections(Country)), Report_Name)

But what was happening is

when country india is selected:

Screenshot1:

When the report Master Budget is selected:

Screenshot2:

But when i clear the country filter i am able to view the data

Can you please help me in resolving this issue

Thanks&Regards,

Anu

[vishsaggi]

Still not sure if this is what you are looking for. why don't you just use country created using subfield for reporting. Like below:

Requirement:

LOAD Name,

     Report,

     Country,

     Session,

     Trim(Subfield(Report, 'Budget',2)) AS Country2

FROM

[..\..\Downloads\Req.xlsx]

(ooxml, embedded labels, table is Sheet1);

Drop Field Country;