Forum Discussion

mstarr13's avatar
mstarr13
Microsoft Employee
6 years ago
Solved

Dynamic Column generation challenge

So I am needing to build a table on the fly. First the structure then I am going to fill it. On the structure, I just want to insert a column for every year from 2007 through 2058. I was trying to do...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    mstarr13 based on your example data table, it is perfect,  use matrix visual, put org on rows, years on columns and # procured on value and you will get what you are looking for.

     

    Would appreciate Kudos 🙂 if my solution helped.

parry2k's avatar
parry2k
Super User
6 years ago

mstarr13 based on your feedback, you should be using year on rows not in columns and then you can visualize the way you want. This is better design rather than having years on columns.

parry2k's avatar
parry2k
Super User
6 years ago

mstarr13 based on your example data table, it is perfect,  use matrix visual, put org on rows, years on columns and # procured on value and you will get what you are looking for.

 

Would appreciate Kudos 🙂 if my solution helped.