Forum Discussion

boyscut's avatar
boyscut
Frequent Visitor
2 years ago
Solved

converting measures to dimension?

Dear Members,   I have a report with a transaction listings of members across different brands. The data is organized similar to the below table: The end goal required, is to undertand what...
Need Help
boyscut's avatar
boyscut
Frequent Visitor
2 years ago

hey Ryan! thanks for following up.

 

This is the expected output:

Thank you.

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
2 years ago

what's the calculation logic? how many member only buy one brand? how many buy two?

  • boyscut's avatar
    boyscut
    Frequent Visitor
    2 years ago

    Hey Ryan,

     

    Thanks for following up.

    Essentially, what I am trying to understand is that from the total memberbase, what percentage of our members only purchase from 1 brand, 2 brands, 3 brands, etc.

     

    Thank you.