Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Different values for index column while creating dynamic attributes

Hi, I'm trying to create a dynamic attribute (so I can change the report if I want to see per geo,per type, per currency etc.) and I followed the instructions in the below link (and I saw similar ex...
Need Help
Tutorial Requests
v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous ,

 

Could you please share your sample data and excepted result to me if you don't have any Confidential Information.Please upload your files to One Drive and share the link here.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi,

    I can't share my data outside my organization. Also I tried it the same excersize on a smaller sample size and it seems to work, but when I go back to my original data the indexes are not acting the same.

    Basically the problem is that after I unpivot the relevant columns the indexes for the original table and for the bridge table are not identical.

    So I get the visual I want but the numbers are not accurate since the index does not refer to the correct row. Any idea why this happens?