I am populating the Excel Pivot table from the sql OLAP cubes . I am having 2 items in the Data Field list and I dragged and droped those two in the pivot table and every thing is working fine .But the problem is when i am selecting two rows and asking to group by right clicking the Data field , It is grouping the rows but it is showing only one column insted of two and the 2nd column is disappering and it is also disappering from the Data Field List and coming back when i say unGroup. I could able to figure out if it is a front end (Excel ) issue or it is a backend (OLAP) issue. Can any one help me on this and also let me know if I am missing any thing in setting the properties.