Forum Discussion

Jelto83's avatar
Jelto83
Frequent Visitor
5 years ago
Solved

Pivot Data into Lists without Aggregation/Counting or Summing the data

Hi,   I'm sure that this is going to be an easy solution for someone out there, but it's had me in circles the last few days.   Requirement: Users require a dynamic dependent dropdown list where ...
Need Help
  • Jelto83's avatar
    Jelto83
    5 years ago

    I've found an iterim own solution to this. I had to add an INDEX Column before Pivoting the data with out Aggretating it and it worked. Now have to format the data around but in essence it has sort of worked.  Would still love a better solution in the longterm - I'm guessing some sort of incremental counter against each Supplier ID

     

Jelto83's avatar
Jelto83
Frequent Visitor
5 years ago

I've found an iterim own solution to this. I had to add an INDEX Column before Pivoting the data with out Aggretating it and it worked. Now have to format the data around but in essence it has sort of worked.  Would still love a better solution in the longterm - I'm guessing some sort of incremental counter against each Supplier ID

 

v-kelly-msft's avatar
v-kelly-msft
Community Support
5 years ago

Hi Jelto83 ,

 

Provide some sample data with expected output here,we would try to give some better solution on it.

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!