4 Replies Latest reply: Sep 23, 2013 4:58 AM by Amelia D RSS

    How to divide expression with dimension (month)

    Michael Carper

      I have a Straight Table chart with three kinds of information: product group (10 categories), gross margin (an expression), and month. I want each product group to be a row, each month to be a column, and then the gross margin for that particular group and month in the cells.

       

      How can I do this? From what I can tell, I can only use product group in the dimensions tab, since putting month in the dimensions tab as well ends up creating a row for each possible product group/month combination. It seems I'll need to involve month in the gross margin expression. Do I need a gross margin expression for each month? Is there a way I can use a variable or function to automatically generate the expression for each month?

       

      Thanks for the help

        • Re: How to divide expression with dimension (month)
          Rohit Koul

          Instead of Straight Table use Pivot Table Dimension as Product Group and Month ... then click and Select Month dimension you will see a Vertical Blue Arrow Highlighted then drag it to right top you will find a arrow changed to horizontal and leave it.

           

          may be this help you

          • Re: How to divide expression with dimension (month)
            Ariel Klien

            Hi,

            You can do a pivot table (in the create chart) and put the month in columns.

             

            Please see the attachment.

             

            i hope this will help you.

             

            BR

             

            Ariel

              • Re: How to divide expression with dimension (month)
                Amelia D

                Hi,

                 

                I need to create one straight table or pivot table. I need to get Sum(Amount) where ActualID=AccountID. for each individual employee. The dimension is EmployeeID. But this EmployeeID and Amount are from one table, whereas ActualID is from another table.

                 

                Could you help me how to write the expression please as it is urgent for me please

                 

                 

                Thanks.

              • Re: How to divide expression with dimension (month)
                Byron Van Wyk

                Hey Mate,

                 

                Change chart object to Pivot and add month as dimension. Drag month dimension to top right corner of where the month dimension is currently. You will see just before you drop the dimension that there is an arrow indicating where the dimension will be populated. If the arrow is pointing to to the right, you good to go

                 

                There are a few differences between straight and pivot tables (i.e subtotals / show partial sums) and it really depends on the design approach and how creative you want to be visually (i.e. show Design Grid > {enables - format cells}). Pivot is quicker to create, but creating an expression for each month is not that time consuming

                 

                Let me know if you come right

                 

                 

                Cheers,

                Byron