When using the analysis mode's pivot mode, please add the ability to expand/collapse entire group levels for both columns and rows.

For example, if I've got multiple column groupings specified, and I want to see all the lowest level values I currently need to manually click each and every expand button down to the lowest level. This can be very tedious if there are many levels and values in the data. It would be nice if this worked like Excel's grouping features do where if there are multiple levels of groupings there are buttons that can be used to expand/collapse all values at the different group levels.

It would also be very nice if there was an option to export to Excel with the row and column groupings imbedded in the Excel file. This would allow faster analysis in Excel at the different grouping levels specified in the BC analysis mode configurations.

Thanks,