Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Problem with segmentation / grouping up data

Hello,   I am using powerpivot to analyse data for an internship. I have an normal dataset with one factstable with all the orders, one costumer table with the costumer names, country etc. and one ...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi Anonymous,

 

Can you share a sample, please? Please mask the sensitive parts.

I think the calculated column is a good idea. It provides the context. So I'm stuck here without a sample.

 

Best Regards,

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi v-jiascu-msft

     

    Well the problem is that all the columns data is in Dutch, so that makes it hard to read for you. Secondly, the company that doens't allow me to share the data. 

     

    I shall make my question more accurate. I want to make a segmentation in my costumers table from the data of my salestable. The two tables have a one to many relationship. I can get the total sales per custumer (just a normal sumx) in a calculated colum in my costumers table. I can make a formula that puts the costumer in groups (if or switch function) but these don't respond correctly when I put the segmentation in the pivottable (as a row). If for example, a costumer has 700k revenue, it still goes in the segmentation big (>1.000.000 revenue). I think this is because my costumers table has a "one" relationship. I can't make a formula that ignores the relationship or something, that it puts the costumer in the right segementation.

     

    Unfortunalty I cannot put a picture in this massage, what would have made it a lot easier to understand.

     

    Thank you for your help.