cancel
Showing results for 
Search instead for 
Did you mean: 

Can we Freeze the Columns in AAO ?

Former Member
0 Kudos

Hi,

I have Crosstab with ten columns in which one is characteristic and rest are Key figures. By default Dimension part is Freeze. Now i need four of my Key figure column to be freeze. Is there any way we can achieve this?

Regards,

Nitesh

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Hi Nitesh,

By AAO do you mean Analysis edition for MS Office or Analysis edition for OLAP? I guess you mean Analysis edition for OLAP. You cannot freeze the measures, as a work around you can do filter by member and select the required measures for analysis.

Regards,

Parag

I_MCA
Employee
Employee
0 Kudos

In addition to Parag's reply you can also reorder key figures using click and drag so the key figures you want to see are beside the ones you want to freeze.

Regards

Answers (0)