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 ,
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.