ignore dimension in expression

[#1]

Hi,

I have the following test expression to ignore dimension in sum. However, the ignore dimension is not working

count({$<CaYear=>}IncidentID)

While CaYear is also selected in dimension fields

Can someone please tell me whats wrong with this expression

Arif

[luciancotea]

Ignore selection in Dimension: count({$<CaYear=>}IncidentID)

Ignore All Dimensions in chart: count(TOTAL IncidentID)

Ignore Specific Dimension (eg: Dim3) in chart: count(TOTAL <Dim1, Dim2, Dim4> IncidentID)

[#3]

count({$<CadYear=>}IncidentID) is not ignoring Cad Year Dimension. Please see attached image

Arif

[luciancotea]

Read again what I said. I think you want option 2.

[Sokkorn]

Hi Arif,

You can try =Count({1} IncidentID) and see the result.

Regards,

Sokkorn