Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi Kaushik,
Your Consulting Services QVW is exactly what I was looking for.
Thanks for the help!
Regards,
Amit