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 ,
Sorry I don't quite understand what you mean, as my screenshot shows, the Agency doesn't show the data when the program \ project level is collapsed.
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.
Here's a screenshot showing all columns having data when the program name is collapsed.
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.