Problem with dimensions

[#1]

Hi!

I need to get str table with one dimension and one expression. Problem is that expression must be calculated using other dimension

(which is not enable in final tab)

i need tab2, as if it was calculated from tab1.

Please help)

[#2]

Hi,

By using "Hide Column" in straight you can hide the unwanted column to display to the user. By this you can have the additional dimension and expression in the same table and at the end just hide it.

Regards

Rajesh

[#3]

Hi Alby,

I hope this is the solution you are looking for. Please check out the attached application for the solution.

Thanks and Regards

Joseph......

[#4]

hi alby,

i'm not sure what's your point but if you need to add table with Dem2 and exp , you can add new chart and select on dimension ( dim2 ) , and on expression ( sum(exp) ) and you can add list box for dim2 to select the dimension you need see total value for.

[#5]

Thanks everyone but i badly explained my problem. I need data to be aggregated by one dimension (dim1) and then- result must be aggregated(sumed) by other dimension(dim2). If i simple hide dim1 data still will be aggregated by dim1- and thats not what i need - i need data to be aggregated by dim2.

Regards

Alby2000