ExcelLikeLayout with measures in row shows incorrect headers

Question

we're using the pivot client control for an olap data source. The pivotclient has the option GridLayout="ExcelLikeLayout" set which for the most part looks fantastic. When i click the toggle axis button it moves the measures to the rows and dimensions to the headers. However now when you look at the grid it hasn't got the row titles correct. The information in the grid is correct but the row headers are not, there seems to be extra totals there where as it should show the headers of the measures.

Measures in columns

measures in rows

Manikandan Murugesan · Accepted Answer

Hi Brett, 
 
We are unable to reproduce the reported problem at our end. Please refer the following video and sample. 
Video: https://www.syncfusion.com/downloads/support/forum/164583/ze/WebPivotDemo-1983986627 
Sample: https://www.syncfusion.com/downloads/support/forum/164583/ze/SCREEN~11192110478 

If still the problem exists, kindly reproduce the problem in the provided sample and revert us (or) send your sample that replicating the problem. This would be a very helpful for us to investigate the reported problem at our end and provide the solution at earliest. 
 
Thanks, 
Manikandan.

Brett Macpherson · Answer

ok for some reason this just stopped doing this, not sure why or how i got it to achieve this but its seemingly working now as i can't recreated it anymore. so all good i guess?

Saranya Sivan · Answer

Hi Brett Macpherson, 
 
Thanks for the reply. 
  
The issue couldn’t be reproduced at our end. So, if you face this again, kindly send us its replication steps which would be helpful for us to proceed further. 
  
Regards, 
Saranya.

Brett Macpherson · Answer

Hi,    I managed to get this to occur again. I enabled paging which (as i've found out) has the effect of not showing the totals (which makes sense as you don't have all the data now it's paged) so with paging enabled the totals don't get displayed and hence you don't get this issue. So with a basic pivot client, enabling ExcelLikeLayout and disabling paging you should be able to get this result.