Forum Discussion

francoisl's avatar
francoisl
Helper II
5 years ago

changing upper hierarchy label

Hi all,    here's a small problem that I cannot find a solution for it.  I have a table of valid product and discontinued product.    Here's the structure.  Master PRODUCT      PRODUCT           ...
Need Help
v-easonf-msft's avatar
v-easonf-msft
Community Support
5 years ago

Hi, francoisl 

The information you have provided is not making the problem clear to me. Can you please explain with an example?

If you can show your expected results in excel, it will greatly help us understand your problem.

 

Best Regards,
Community Support Team _ Eason

 

  • francoisl's avatar
    francoisl
    Helper II
    5 years ago

    Here you go.  Two pictures where the roll-up is done in the first Active item while the others are DISCONTINUED. In this exemple item C was replaced by B and then by A. However we want all sales to be aggregated to the latest item wihout losing sight of sales of older items.   The hierarchy in the matrix summarizes correctly the units, dollars and so on but for the item description I have either first or last but it is sometimes inaccurate.  In this example I would like to have SDF as the mast item description. 

     

    Here's the basic relationship between tables.