Hi Can you give me any solution for this
Sorry but what do you expect? You are talking about your own model, nobody else know how it looks like, you are the only one knowing how to get the month from the customer because it depends on your model. So do you really expect that we are able to post you a piece of code?
Build an analysis and get the month there by using a filter on the customer name, when done copy the LSQL from here and adapt it for your prompt.
PS: you can also hire a consultant who will be happy to study your model and write the right code for you ...
Thanks for your reply!! I am just asking weather it is possible are not. The above code has given for just better understanding purpose.
Of course it's possible if your model is build correctly to link these 2 info together, using the implict fact table it will also work by itself, but again it really depend on how your model and data looks like.