Forum Discussion
undefined
Hi mcantos - I have some key ideas, please check once.
Create a measure for each cell you need to populate (based on Stage and Status), which will avoid the need to create 9 or 6 separate datasets.
A matrix should work for cross-tabulation of Status and Stage. It dynamically expands and simplifies the table structure.
Focus on formatting and grid alignment to make the matrix look as close to a report as possible.
This approach should give you more flexibility than manually creating separate datasets for each table while keeping the report structure more maintainable.
Hope the above informaiton helps.
Hi mcantos - I have some key ideas, please check once.
Create a measure for each cell you need to populate (based on Stage and Status), which will avoid the need to create 9 or 6 separate datasets.
A matrix should work for cross-tabulation of Status and Stage. It dynamically expands and simplifies the table structure.
Focus on formatting and grid alignment to make the matrix look as close to a report as possible.
This approach should give you more flexibility than manually creating separate datasets for each table while keeping the report structure more maintainable.
Hope the above informaiton helps.
Hi rajendraongole1 ,
Sorry for the delay. The idea about using measures worked 🙂 so, thank you so much.
I have a quick question
Is there a way to remove the blank cells? I want each cell to start from the top. Is it possible?
Thank you!