Expressions should show the values in Straight table irrespective of any Nulls in Dimensions

[nakuldev]

Hi All,

In a straight table I will be having 20 Dimensions along with 15 expressions in which usually data will be populated as per the matching records. But as per my requirement if any of the dimensions have Null values and doesn't have any match with the expression, it should consider the existing dimensions and should display the value based on that.

For example I have Country with all the remaining dimensions as nulls but it should consider the country as base and should show avg(Value) based on that country or dimensions which are all available.

PFA attached sample. 

Country	Region	City	Value	Output
India	APJ	Delhi	10	10
USA	AMS	NY	20	20
Malaysia	APJ	KL	30	30
India		Mumbai	5	5
India				15

Thanks in Advance

Nakul

[olivierrobin]

hello

why don't you use a crosstable, make a total at country level and so use avg()