Forum Discussion

Rnaval's avatar
Rnaval
Post Partisan
2 years ago
Solved

Need help with a Matrix Visual

I have an Excel file with Programs and the Projects that roll up under it. I created a Matrix Visual for this but it's not working as expected. I want to list the program name only without any associ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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. 

Rnaval's avatar
Rnaval
Post Partisan
2 years ago

Here's a screenshot showing all columns having data when the program name is collapsed.

 

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.