Forum Discussion
Creating a table with multiple values filtered from same table
I have a table where the Loan Number for multiple sources reside on the same table. The field which differentiates it is the Type Column. I already created a column for each loan number (Owner Loa...
I'm having a hard time following what you describe, but just from looking at your demo data, you are trying to pivot the Number field by RootId# so that for every RootId# you have 3 columns?
What I am attempting to do is pivot the number field with the Type so that the 2 of the 3 Number types will display on the single rootId#.
I did manage to add a SQL data source using a SQL query with a degree of success. Only thing with this was that I was only able to Import vs DIrectQuery. So I am definitely getting closer to my solution.
I really appreciate all of the feedback since it is growing my knowledge greatly.