Skip to Content
0

Collapse columns

Dec 18, 2017 at 10:26 AM

24

avatar image

In Webi, how to create to collapsable columns?

There are 3 columns from three variables, containing measures at present (a cross tab table report).

Column1 = Numerator/Denominator

Column2 = Numerator

Column3 = Denominator.

These columns come under horizontal dimension (year).

year

COL1|COL2|COL3|

The report should show only Column1 against all dimensions, i.e. column2&3 should not show by default.

But a user should be able to expand Column1 to the right showing column 2 & 3.

Regards,

Cleo

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Koen Hesters Dec 19, 2017 at 08:07 AM
0

set break on year and (footer only) add your measure 1 in the footer of the break, collapsed it should show only footer, ie measure 1 and expanded it should show all measures per year

Share
10 |10000 characters needed characters left characters exceeded