11 Replies Latest reply: Jan 23, 2013 10:24 AM by Amit Kakkad RSS

    Dynamic Dimension on Charts using $Field

    Deepak Vadithala

      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