Pivot Table

[sspawar88]

Hi

i have Pivot table in which dimensions are branch_type and region_name.

Expression consist

Count({$<param_name={'Temperature'},param_value={'<=-1'}>}param_value)/

Count({1<param_name={'Temperature'},param_value={'<=-1'}>}param_value)

Requirement is when i select on some region_name or branch_type.

i want only related items in Pivot table.

But now it gives all other items as o or Null.

what changes needs to be done?

[swuehl]

Please post a small sample QVW.

[Anonymous]

It should work as you described without any additional efforts.  Maybe something is wrong with your data or data model.  Can't tell without an example.  Try if this returns anything:

count(param_value)/count(total param_value)