Can the fields (dimensions and measures) listed in PivotConfigurator be restricted, so that we can restrict to only those relevant for the end user

Thanks

Hello
I am trying to save kendo PivotGrid state for future load but I can't find a way to save/load the selected feilds (slices) using the "Fields to Include" menu along side with rows,columns and measures.

Is there any way to get and set selected fields in kendo PivotGrid?

Hello
I am trying to save PivotGrid state for future load.But I have a problen: The expand property of row items is not changed at run time. Test here https://dojo.telerik.com/@Mzand/obIkEdAY : When the user expands an item at runtime the expand property of the returned row by dataSource.rows() is the same as what it was at initialization. Isn't it data-binded? Is there a way to get the value?

Hi,

I have Multiple Column and Rows fields.

• Column: Year (i.e 2018, stored as a int (tried DateTime and String also) and Month (i.e April, stored as DateTime)
• Row: Name (i.e. Lee Stevens, stored as String) and Charge Type (i.e. Annual Leave, stored as String)

Now, when i sort ONLY the columns OR row, the results display as they should but when i want to Sort from both it "can't" I guess and gives up.

For example when i sort the Column (Year, Month)

This work perfectly fine, It display the Year(s) (i.e. 2018, 2017, 2016) then the Months in order (I.e. Jan, Feb, March)

But as soon as i introduce the sorting the row also they then stop ordering correctly:

The order becomes: 2017, 2019, 2018. Nov, Dec, April, Jan (they seem to loose there sorting?)

Any ideas?

Thanks,
Lee.

hey, i'm ecaluating the pivot grid using the trial version. i seem to have problems getting angularjs and the pivot templates to work together.

my script imports in the index are as follows: 

  <script src="bower_components/jquery/jquery.js"></script>
    <script src="bower_components/angular/angular.js"></script>
    <script src="bower_components/kendo-ui/js/kendo.all.min.js"></script>

in the HTML page i have: 

    <div class="col-md-12" ng-if="vm.data.HeatChartSkillsPerResource && vm.data.HeatChartSkillsPerResource.length > 0">
        <kendo-pivot-grid  k-data-source="vm.dataSource" k-options="vm.options" id="pivotgrid" class="hidden-on-narrow">
            <div k-column-header-template>
                {{member.caption}}
            </div>
        </kendo-pivot-grid>

in the relevant controller: 

    vm.dataSource = new kendo.data.PivotDataSource({
                    data: vm.gridOptions.data,
                    schema: {
                        model: {
                            fields: {
                                FullName: {
                                    type: 'string'
                                },
                                skill_rating: {
                                    type: 'number'
                                },
                                skill_name: {
                                    field: 'Skill.SkillName'
                                },
                                Category: {
                                    field: 'Skill.Category'
                                }
                            }
                        },
                        cube: {
                            dimensions: {
                                FullName: {
                                    caption: 'Resources'
                                },
                                Category: {
                                    caption: 'Categories'
                                },
                                skill_name: {
                                    caption: 'Skills'
                                }
                            },
                            measures: {
                                'Average': {
                                    field: 'skill_rating', aggregate: 'average'
                                }
                            }
                        }
                    },
                    columns: [{ name: 'FullName', expand: true }],
                    rows: [{ name: 'Category', expand: true }, { name: 'skill_name', expand: true }],
                    measures: ['Average']
                });

        vm.options = {
            columnWidth: 100,
            height: 500,
            filterable: true,
            sortable: true,
            reorderable: false
        }

the data is loaded as expected but column header templates (or any other templates) don't recognize angularjs. what i see is {{member.caption}} inside the headers. (as in the attached file).

i don't see any errors.

any help on that?

Hi,

I have found a problem when having text with ampersand in the data used for a pivot grid when expanding the row or column with that ampersand in the caption.  A JavaScript exception is caused in the browser (Chrome & IE).  The exception is "Uncaught TypeError: Cannot read property 'value' of undefined at init._buildRow" in kendo.all.js:73938.  The undefined object is dataItem.

I have encoded the ampersand using &amp; within the string at the datasource and whilst that is displayed correctly I believe the & within the encoded &amp; is still causing the exception.  I have tried using the rowHeaderTemplate and the row encoded property but neither seem to stop the error from occurring.  Is there another way I should be encoding this text so that it doesn't break the JavaScript code?

My original project is Kendo UI for MVC but I have created a dojo using the JavaScript version to re-create the problem.

dojo.telerik.com/@amdenley/OkEqIV/2

Hello.

Is there any way to export a large PivotGrid to a multipage pdf file?  PivotGrid PDF configuration doesn't seem to support "multiPage" setting.

For example, my grid can contain 150-200 columns and ~100 rows. Wondering if there is any way to save such a grid  as a set of A4 pdf pages.