How to Collapse The Table So That The

[peersbrennanctb]

Hi

I want to be able to collapse and expand the months in this table how can i do this.

Thanks

[JefB · Accepted solution]

What is your source model connected to?
You need to make sure that your source model has a hierarchy on that dimension or that it's recognized as a Date dimension by SAC.

[peersbrennanctb]

Sorry so what would the steps be to so i can expand and collapse the months in this table format.

jefb jefbaey

[JefB]

if you want to expand/collapse, you need a hierarchy

if you want to see the totals -> right click the "Month" header to see the total value per Depot

if you simply want to let user switch to see only totals / vs only month detail values -> add a button with onClick() event and something like

Table_1.getDatasource().removeDimension("Month");
//or Table_1.getDataSource().addDimensionToRows("Month");

[sandip_kumar003]

Hi,

It seems like, there is no hierarchy for the months so need to first create a date dimension

in such a format where at least a year and month should be present.

Best Regards,

Sandip Kumar.

[peersbrennanctb]

Thanks, wasn't sure if there was another way.

[JefB]

Well, you could display totals line and probably also make a button with an onClick() event to add or remove the "Month" dimension dynamically. But that's not the standard collapse/expand as a hierarchy would give you.