I am using pivot table. current existing column expression is (Count(distinct id)), using count function not sum function. if i am changing the count function to sum then my existing column logic is changing. Also note that if I am applying the above logic i am not getting the expected results. (getting '-' in column). Please advice.