2 rows with different categories in the same installation code

[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 ,

As you described in the first half of your paragraph, creating category1 by judging the field VN A=1; creating category2 by judging VN A=1 and VN VW=1. But the second half of the description seems a bit confusing to understand.

Are you able to further describe your requirements and provide the desired result outcome for my further testing.

Looking forward to your feedback.

Best Regards,

Stephen Tao