8 Replies Latest reply: Dec 6, 2012 11:37 AM by Michael Solomovich RSS

    Visibility chart

      Hi guys and girls,

      i have a very special case to solve,pls help me...

       

      I have a container box with imported pivot tables (a pivot tables are similar in structure dimensions,only conditionals in expressions are direrent).

      Above it i need to create bar chart with dimensions common to all tables ---> Than i need to do some adjustment for changing a expressions values in chart,when i´m switching between tables in the container box.

       

      Than as a bonus you could tell me,how put some chosen dimension to secondary axes (as in Excel),i cannot find it in options

       

      Thx so much:-)

      Jerry

        • Re: Visibility chart
          Michael Solomovich

          Jerry,

           

          I think that using container here is not the best idea.  I'd rather use only one pivot table and only one bar chart, and make expression (in both) conditional.  To switch between conditions, you can use a variable or a field.

           

          Regards,

          Michael

            • Re: Visibility chart

              Ok,i´ll try it....could you pls tell me an answer to point nb.2 - secondary axis ?!

              Thx a lot

              J.

                • Re: Visibility chart
                  Michael Solomovich

                  I'm not sure I understand exactly what you want.  Here is what I use for "selected dimension".
                  Created a field %Dimension (as logical island) which contains the list of the field names which I allow to use as chart dimensions (e.g. City, Client, SalesRep...)
                  The chart (bar or line) itself has two dimensions.  The first one is time, e.g. Month.  The second is calculated:
                  =$(=%Dimension)
                  List box %Dimension allows only one selected value.  User selects 'City' - and City is the chart dimension.

                   

                  Hope it may give you a hint, even if it's not what you're looking for.

                   

                  Regards,
                  Michael

                    • Re: Visibility chart

                      Dear Michael,

                       

                      i´ll try explain it by concrete case.

                      I have a chart with 2 dimensions (year,month) and then 3 expressions (one value in milions and next two in %).When i want to display all expressions in one chart,so i need to take expressions in % and put them to secondary axes to the right, because if i wouldn´t do it i´ll see only bars with milions of first expression and % not. In excel is a function "series options"- secondary axes (when you select menu for one of columns).

                      If i could put a chosen expressions to secondary axes on the right site of a chart i´ll see all three expressions in one chart.

                       

                      Thank you for an advice

                      have i nice day

                      J.