Forum Discussion

Sebastián_Limon's avatar
Sebastián_Limon
Regular Visitor
3 years ago
Solved

Count transactions by category

Hi, I need help with a measurement. I need to count how many transactions certain amounts of product categories contain. The categories can be three Calzado, Ropa and Accesorios. For example, I...
"Ayuda"
"Need Help"
  • WinterMist's avatar
    WinterMist
    3 years ago

    Sebastián_Limon 

     

    OK, for some reason that I don't fully understand, I had to create a 3rd measure to make the total work correctly.

    (I believe it has to do with context transition.)

     

    Anyway, here are the 3 measures:

     

     

     

     

    Results:

     

     

    Hopefully this is helpful to you.

     

    Regards,

    Nathan