Hi all,
I am trying to achieve collapse and expand in designer report.
For example: We have taken three hierarchies and one measure in MS Excel and we want to achieve same in the designer report.
It is easier to construct a table visualization in Visualizer which has an easy implementation of Break By. And on the export to Excel, you can select whether you want to export all the data expanded (which carries the break by's into Excel) or as you see it on the screen (as shown in your screenshot).
