Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

matrix issue

     real result  
         
 januar februarmarch  januar februarmarch
code123 code111

 

basicaly i need to count homeany time happen a code in a month

in this exa,ple i say is happen 1 time month

so i should have as result like in inthe right 

for every month all 1

but instead i got result as left

it s make the sum of every month progressive,

how i cna display just the count for a single month

?

3 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar

    Hi Anonymous,

     

    From your information, it seems that the result in right is your desired and the result in left is your current result?

     

    If it is, could you share your data sample so that I can help you create the correct matrix?

     

    Best Regards,

    Cherry

    • Anonymous's avatar
      Anonymous
      Not applicable

      From your information, it seems that the result in right is your desired and the result in left is your current result?

      YES

      v-piga-msft

       

      right i cant paste and example can you try to use the one i posted?

      • v-piga-msft's avatar
        v-piga-msft
        Resident Rockstar

        Hi Anonymous,

         

        From my understand, you posted is your result output not the data sample?

         

        You just share your dummy data  sample which could reproduce your scenario then I could copy and test on it.

         

        Best  Regards,

        Cherry