Straight Table non selectable rows

[#1]

Hello,

I have this straight table which has Territories as its dimension.

Territory	Volume
A	5
B	10

Presently clicking on any of the rows of territory filters the entire report for that particular territory only.

Desired state:

Clicking on the entities of the territory has no effect.

Methods Tried:

Invisible text box on top of the table. Issues does not render well when viewed with IE plugin.

Any suggestions please

[pover]

In the volume expression, insert set analysis to ignore a selection to Territory,

sum({$<Territory=>}  Quantity)

Karl

[Anonymous]

Check "read-only" in the chart properties, tab General

[#4]

There are 4 conditional Dimensions.

I only need to deactivate one of them.

So read only is not applicable here.

Original Expression:

num(sum(distinct(if(product='XYZ',( comparitive.volume)))),'#,##0')

Tried:

num(sum(distinct({$<GeoID=,product='XYZ'>} comparitive.volume)),'#,##0') (Does not work. Error in expression)

Suggestions???

[Larry_Aaron · Accepted solution]

Syntax wise you need { } around the 'XYZ' and some other changes

num(sum({$<GeoID=,product={'XYZ'}>} distinct comparitive.volume),'#,##0')

[#6]

Thnx a lot guys for helping me out