Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

stock column values

Hello ,

 I want to search the number of customers who have buy in month september but not in octobre .

I didnt know how to stock the ID of customers how have already buy something in september to verify after if they   have also buy somthing in octobre 

ID CUSTOMERsptembreOctobre
310
210
200
301

In my case choulf only 1 ( the custumor number 2)

Need Help

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    7 years ago

    You should probably pivot/unpivot your month columns and then it should be relatively trivial.

    • v-frfei-msft's avatar
      v-frfei-msft
      Community Support
      7 years ago

      Hi Anonymous,

       

      Has your issue been solved? If so, kindly mark the answer as a solution to close the case. If any other question, feel free to let me know please.

       

      Regards,

      Frank