Dynamic Dimensions

[Anonymous]

Hello,

I am looking for some help.

In one of our reports, we wanted to give users the option of choosing the combination of dimensions they wanted to choose. I am trying achieve below features in my report. Lets say I have ten Dimensions Dimension1,Dimension2,Dimension3....and two expressions sum(sales),sum(taxes)

1) I wanted to provide the list of dimensions available for the user to choose .

2) I wanted build a straight chart where users will be looking into the dimensions they selected above and sum(sales),sum(taxes)

3) If users choose only Dimension1 they should only see Dimension1,sum(sales),sum(taxes) in the straight chart and if they select  dimension2 in combination to Dimension1 they should see Dimension1,Dimension2,sum(sales),sum(taxes) and so on.

I tried using the $Field in a list box, and then used the same as Dimension in my straight chart, but I cannot limit the Dimensions here.

Any help would be highly appreciated.

Thanks

Heera

[swuehl]

Starting with QV11, you can use conditional dimensions and expressions to do what you want.

There is a demo on how to do this in the 'What's new in QV11' sample application.

[ramoncova06 · Accepted solution]

Customizable Straight Table

here is a how to

[Anonymous]

Thanks a ton. It helped me in solving my problem.

Thanks