Data Selection and Dimensions

[saifuddin]

Hi All, 

I need some advice with a problem I am trying to solve. My chart expression shows value only if the Dimension field in available on the sheet. 

without dimension

Without Dimension week2 expression value in null. 

with dimension

Expression: 

=if(ValueList(CUM_WK2)=CUM_WK2 and CUM_WK2<>-1,

      Count(DISTINCT (if(U18_DT>CUM_WK2, PEOPLE_ID))))

Appreciate your help. 

Thanks

Saif  

[asinha1991]

---

@saifuddin wrote:

Hi All, 

I need some advice with a problem I am trying to solve. My chart expression shows value only if the Dimension field in available on the sheet. 

without dimension

Without Dimension week2 expression value in null. 

with dimension

Expression: 

=if(ValueList(CUM_WK2)=CUM_WK2 and CUM_WK2<>-1,

      Count(DISTINCT (if(U18_DT>CUM_WK2, PEOPLE_ID))))

Appreciate your help. 

Thanks

Saif  

---