How can I see the items which setted in drill behaviour in View Tabular Data?

[ersin.gulbahar]

Hi,

I have a chart. And I allow Drill up and Drill down option.
I have a filter that it effect my chart.
When I want to view tabular data with setting my parameter , I dont see which I want.Its just show data items like dont effect paramater.It s dont filter problem.

When I run report and click markers on the chart , drill down works and look true but when the value promt change everythings look normal but the conditional style is wrong. I think and belive the main problem is drill down option.

(
for example : I have two columns. region and topregion.
If I look view tabular data without setting parameter , the result is :

region      topregion
--------      ------------
a              X
b              X
c              X

And when I look view tabular data with setting parameter(topregion = ?p1?)--p1:a

region      topregion
--------      ------------
a              X
b              X
c              X


but you know it dont like that.
I want to see it like this :

region      topregion
--------      ------------
k              a
l               a
m             a

but it dont.

How can i fix this?

thanks...

)

[MFGF]

Using detail filters like this in a report based on an OLAP package is a very bad idea. You will often see unpredictable or incorrect results. Instead, change your TopRegion item to be a query calculation with the expression [Your TopRegion level] -> ?p1? and delete your detail filter.

MF.


Sent from my iPad using Tapatalk HD