Hi All,
I want to calculate distinct count from multiple columns.

In calculation view, by dragging the SO and PO number, the distinct count of SR values are incorrect. ie) 5. Expecting output as 1. How to design on distinct count the multiple Columns (SR, SO and PO). For getting unique SR, i kept SO_NUM and PO_NUM as transparent filter to TRUE. But in this layer, i am calculating the SO and PO count, so getting the error as "Transparent filter property not allowed for view attributes which are referenced in expressions(calculationNode (finalAggregation) -> attributes -> attribute (SO_COUNT) -> expression). How to perform distinct count on multiple columns in final aggregation.
As i searched in old forums, i didnt proper solution for this issue.
Thanks.