Forum Discussion
Need help with a Matrix Visual
Hi Rnaval ,
Based on my understanding, it seems like you are working with a spreadsheet that has multiple tabs and you are using drill-through pages to display data for programs and projects. It sounds like you want to know if you can use the same tab in the spreadsheet for both the program drill-through and the primary data, and pull the data from the first line of the program name. Without knowing the specifics of your spreadsheet and data structure, it's difficult for me to give a definitive answer. However, in general, it is possible to use the same tab in a spreadsheet for multiple purposes and pull data from specific cells or rows based on certain criteria.
Please create a new thread to provide detailed information and other questions, there will be more engineers and users to help you.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Rnaval ,
Due to the design, it is not supported to directly have columns not display data when collapsing the program name. You need to create measures to place on the visual object instead of columns.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
It seems it is possible according to what Greg Deckler provided in message #2, see screenshot below.
Hi Rnaval ,
I apologize for misunderstanding your point.
You need to click on [Row headers] -> [Options] -> Turn off [Stepped layout] in the [format your visual] pane.Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks, This format is different than what I expected. I'll keep the current format as it saves space on the matrix visual. I final question - I have drill thru pages - one for Program and one for project - For the Program drill thru, I use a different tab in the spreadsheet (Program Status Tab) for the data, can I instead use the same tab of the spreadsheet (Primary Tab) and pull the data from the first line of the program name?
Hi Rnaval ,
Based on my understanding, it seems like you are working with a spreadsheet that has multiple tabs and you are using drill-through pages to display data for programs and projects. It sounds like you want to know if you can use the same tab in the spreadsheet for both the program drill-through and the primary data, and pull the data from the first line of the program name. Without knowing the specifics of your spreadsheet and data structure, it's difficult for me to give a definitive answer. However, in general, it is possible to use the same tab in a spreadsheet for multiple purposes and pull data from specific cells or rows based on certain criteria.
Please create a new thread to provide detailed information and other questions, there will be more engineers and users to help you.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.