Drill down not working.

[ganeshreddy]

Hi All,

I got an issue here, drill down for total equipment(Last metric) in first table is not working. That expression contains complex set expression. help me to rectify this. Please find attached QVW.

Regards,

Ganesh.

[swuehl]

I think you need to resolve the current fields from dimension group in the advanced aggregation and maybe use the set expression also on the outer aggregation:

sum({<EquipmentGroupName=,EquipmentClassName=,EquipmentCategoryName=,EquipmentModelName=>}

aggr(

Count({<EquipmentGroupName=,EquipmentClassName=,EquipmentCategoryName=,EquipmentModelName=>}

          distinct EquipmentId)

,$(=GetCurrentField( Organization ))

)

)

[ganeshreddy]

Hi MarcoWedel‌

Nice to see you after long time in my post, please help me on this issue.

Best Regards,

Ganesh.

[ganeshreddy]

Hi Swuehl,

thanks for the reply, I tried this already but its not working. Here total equipment in both table should match, not happening in this case. Do I have to make any changes in data model? please help me here.

Best regard,

Ganesh.

[ganeshreddy]

Hi Swuehl,

I tried to put that get current field logic in condition for that expression, it is not working. have you got any idea on this.

Best Regards,

Ganesh