Dynamic Dimension on Charts using $Field

[IAMDV]

Dear All,

I have many dimensions in my report and there is space constraint on the design layout. So we had decided to show only 4 dimensions at any given time. I mean 4 pie charts with same expressions. And I am using the SYSTEM TABLE FIELD - $Field for displaying the list of dimensions. And below is my chart expression...

Chart Dimension Expression : =($(=$Field))

Chart Expression : COUNT({$} Resp_ID)

This works fine for the first chart. Now I wanted to simulate for the 2nd, 3rd & 4th charts. I mean I thought I could use SET IDENTIFIER ($_1) for the 2nd Chart and then ($_2) for the 3rd Chart...

However I can't use the SET IDENTIFIER in my Chart Dimension Expression : =($(=$Field)). Please can someone help me on this? Or please suggest a better appraoch if any...

Many thanks in advance.

Cheers - DV

[IAMDV]

Erich - This is exactly what I needed!! Many thanks for your help. Although I had created subroutine in VB Script to get working. However, I prefer to use the Set Analysis solution instead of VB Script.

Sridhar - Thanks so much for taking time to provide demonstration. I had marked your post as Helpful

Cheers - DV

[#3]

Hi Kaushik,

Your Consulting Services QVW is exactly what I was looking for.

Thanks for the help!

Regards,

Amit