Expanding Columns like Excel

[#1]

Hello all,

This keeps coming in as a user request.

In Microsoft Excel you can group a set of columns together so they have a total but you can hide and show the details.

What's the best way to do that with a straight table or a pivot table?

Russ

[Anonymous]

ok, you can do it with columns. but can us do the same with rows? favourably without a macro? or if macro is a must, is it possible? Thanks.

[geam1988]

Hello John,

I have 2 dimension and 19 expressions in a report.

6 expressions are sales related, 9 expressions are production cost related and 4 expressions are administration cost related. I want to collapse expression and it should be expandable on a click. Something like + , - option. i did something like this as per your comment but it is not working.   Any suggestion ?

Best Regards

kazi

all expressions with condition like above

I am not sure, what should i do with variable Overview. there i did now write anything.