Set analysis

[sspawar88]

in one Bar chart in which dimension is region_name and expression is :

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

Count(total <region_name>{<param_name={'Temperature'},param_value={'<=-1'}>}param_value)*100

in another bar chart in which dimension is branch_type and expression is :

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

Count(total <branch_type>{<param_name={'Temperature'},param_value={'<=-1'}>}param_value)*100

In Pivot table i have two dimensions region_name and branch_type and expression is :

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

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

Can i get the same value in pivot table same as both bar charts ?

[#2]

Hi,

Possibly yes! Looks fine to me

it would be best if you could experiment with the data and show what you've got