Two categories with same installation code in two different rows

[Anonymous]

Dear all,

I'am trying to create two different categories, one to identify when VN A=1; in this case the name of the category would be "Sales VN A" and tother one to identify when VN VW=1; in this case the name of the category would be "Sales VN VW. However, when one code (Código instalacion) has VN A=1 and VN VW=1, I would need to separate the code into 2 different rows: One with the category "Sales VN A" and other with "Sales VN VW".

How could I do it?

Thank you

Xavi

[v-stephen-msft]

Hi @Anonymous ,

Sorry, not very clear.

Can you provide sample data and expected results?

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.