Displaying data tables according to dimension elements

[spartan]

Hello All,

I have a scenario like, I need to display a table of 2 rows ad 5 columns for each element in a dimension. If a dimension has 2 elements i need to display 2 tables, it depends on the number of elements in a dimension.

1. How to display the tables according to the number of elements in a dimension. Is it possible to show only the number of tables that are equal to the number of elements in a dimension.
2. Is their any way to hide the tables according to the dimension size, as i a using the sheets in web. I guess VBA code does not work.

[Wim Gielis]

So you have a 2D table and another dimension. If my maths is still correct, 2 and 1 makes 3.
So how about creating a 3D cube... and a report on the cube with 2 stacked row dimensions ?

[spartan]

So you have a 2D table and another dimension. If my maths is still correct, 2 and 1 makes 3.
So how about creating a 3D cube... and a report on the cube with 2 stacked row dimensions ?

Hello,
So cant we show only the number of tables according to the number of elements of a dimensions, like if my dimension has 5 elements i need to show 5 tables,
I am thinking to create 15 tables, and display all tables according to number of dimension elements, remaining has to hide. Because if a dimension has only one element if the tables were not hidden all 15 tables are displaying with no values.

[Wim Gielis]

That’s what we would call zero suppression on the outer row dimension...