Creating a button to expand rows and columns

[Rinaldi]

Hi All, 

I have created a page using pivot table and I want to create a button that can expand all the rows and columns.
Do anyone here know how to do that?

Regards,

Rinaldi

[Georgi Krustev]

Hello Rinaldi,

I would suggest you use the PivotDataSource expandColumn/expandRow methods:

var pivotDataSource = $("#pivotgrid").data("kendoPivotGrid").dataSource;

 

pivotDataSource.expandColumn(["Category"]);
pivotDataSource.expandColumn(["Category","SubCategory"]); //second dimension



pivotDataSource.expandRow(["Division"]);
pivotDataSource.expandRow(["Division", "Channel"]); //second dimension


The expand methods expects dimension path. That is why you need to define the full path for the second dimension.

Give a try and let me know how it goes.

Regards,
Georgi Krustev
Telerik

 

 

[Oaww]

hello,

        But If need to expand all Column & Rows,it seems to do

       ["Division&B2B","Channel"] and so on...not expand all rows & columns,just the summary row & summary column

[Georgi Krustev]

Hi,

Yes, if you would like to expand the second dimensions of each member of the first dimension, you will need to execute the expandRow/expandColumn with the specific member path.

Regards,
Georgi Krustev
Telerik

 

 

[Bruno Larose]

Is there any other way to expand all further then expanding path by path?

[Georgi Krustev]

Hello Bruno,

I am afraid that currently widget cannot execute batch expand operations to SSAS instance. The only solution is to expand the dimensions level by level:

• http://dojo.telerik.com/@ggkrustev/eNOxu

Regards,
Georgi Krustev
Telerik

 

 

[Webster Velasco]

is there a way to get all possible path with current version in order to expand everything?

like this http://orbjs.net/

[Konstantin Dikov]

Hi,

You could try to retrieve the paths from the expand/collapse icons through the data-path attribute:

<span class="k-icon k-i-arrow-e" data-path="["[Geography].[City].[All Geographies]"]"></span>

Hope this helps.


Regards,
Konstantin Dikov
Telerik by Progress