HI, Recently, we have a business requirement, we need show two types which the number of customer with OR value and without OR till now as a dimension in a pie chart. But when I select month, it only show the number of customer with OR. how to show the types in the dimension? I try to write something as below, But it seems not work.
sum( FROZENDATE= {"<=$(max(FROZENDATE))"} ORValue)+0*sum( {1} ORValue)