Downloading and showing footers

Question

Hi there! I need to export the pivot Table with all the data expanded, but need to show the page of the table with the data collapsed. Is there a way to do it?

and another thing... I need to show the totals the whole time, but the more data I load the go down and down. Is there a way to put a footer that shows me the totals the whole time and not have to scroll it down to see it?

AngelinFaithSheeba PaulvannanRajadurai · Answer

Hi Nelson,Please find the response below: Query Comments I need to export the pivot Table with all the data expanded, but need to show the page of the table with the data collapsed. Is there a way to do it? Currently, we don't have any options in our pivot table to meet your requirements. The pivot table's current cell information as displayed on the browser page should always be exported when exporting the pivot table. I need to show the totals the whole time, but the more data I load the go down and down. Is there a way to put a footer that shows me the totals the whole time and not have to scroll it down to see it? We regret to let you know that, currently we don’t have support to freeze the grand totals. However, you can position the grand total at first position by using the GrandTotalsPosition property. Please refer the below code example. Code example: Meanwhile, we have prepared a sample for your reference. Sample: https://www.syncfusion.com/downloads/support/directtrac/general/ze/PivotTable-197953298 Screenshot: Please let us know if you have any concerns.Regards, Angelin Faith Sheeba.