How to get Last Column of a pivot table ?

Question

Hi ,I have to make two or more pivot table in one sheet. When I am trying to do I need the last column of the first pivot table to place second pivot table horizontally, sometime 1st pivot table is overlapping the second pivot table.Here I need your help to get the last column of a Pivot table.So that I can start my second pivot table from the last column of the first pivot table.Thank youAbdullah Al Mamun

Sivamathi Natarajan · Answer

Hi Tumulabdullah, 

We regret you to let you know that the requirement couldn’t be achieved in pivot table. Because, each column values are generated by aggregating its raw items(data source). And, the pivot table accepts only the data source but not columns as its input. 

Regards,Sivamathi.

Harsh Shah · Answer

May this will help you to get last column  of pivot table  :-   http://https://www.mrexcel.com/board/threads/find-last-column-and-select-data-from-pivot-table.702680/post-3470641

Sivamathi Natarajan · Answer

Hi Tumulabdullah, 
 
Thanks for the link. 
 
The pivot table does not have the option of finding the last column and slicing it with the code-behind. But with the help of the selection feature, you can manually select the desired cells and get the selected cells by event. Please consider the UG and the demo for reference. 
 
UG: https://blazor.syncfusion.com/documentation/pivot-table/row-and-column/#selection,  
        https://blazor.syncfusion.com/documentation/pivot-table/row-and-column/#event  
Demo: https://blazor.syncfusion.com/demos/pivot-table/selection?theme=bootstrap4 
 
We hope the above will meet your requirement. 
 
Regard, 
Sivamathi.