Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Please post a small sample QVW.
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)