Variable as Dimension

[#1]

Hi,

I need help to generate a chart with variable as x-axis dimension.

Please refer the file attached. It has a field Customer, and user can create groups of customer then in the chart instead of Customer in X axis I need Groups in X axis.

Thanks,

Sumita.

[fosuzuki]

Are you in v11? If so, I'd recommend using Alternate States. Attached modified qvw.

[#3]

Thanks Fernando Suzuki for your reply.

But I'm still stuck with V9, so this isn't working for me.

Sumita

[fosuzuki]

So check this old sample. It uses a macro to store the groups in different bookmarks, and the uses the bookmarks in the set analysis.

I'm pretty sure I've downloaded it from this community, but don't know anymore to give the credits.

[#5]

Thanks Fernando Suzuki, your second post was quite helpful. I shall update my solution soon, just for reference.

Sumita