Cube in Report Studio - filter

Hi ,

Could you please help me with filtering of data from report studio when using cube/Olap package.

Example :

I have report in which I need to filter data based on the country.

There are three country A,B and C.

In a report I just want to show data with A and B data excluding C.

Here I am using cube as source in report studio.

Thanks in Advance


Try this FILTER(set([Country A],[Country B],[Country C]))

Read more about dimensional functions here:

or make a prompt in the prompt page