Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I want to get the values which are different than DISTR on the column 'Período de Faturação', so I don't have duplicated values (as shown on the image below). Any I idea of what should I use on 'Período de Faturação' to make it happen?
Thanks in advance!
Solved! Thanks!
Try using as follows
Dimension 1 : Contract_No
Dimension 2 : Customer Name
Dimension 3 : If ( Período de Faturação <> 'DISTR' , Período de Faturação , Null() )
Dimension 1 : Contract_No
Dimension 2 : Customer Name
Dimension 3 : If ( Período de Faturação <> 'DISTR' , Período de Faturação , Null() )
Last uncheck the Include Null Value option for the third dimension
Solved! Thanks!