Forum Discussion

Rsanjuan's avatar
Rsanjuan
Advocate III
10 years ago
Solved

Adding rows and allocating total for one column

Is it possible to enter rows in the query editor and enter in data manually?  In the graphic below, I'm looking to take the value of 83500 and spread it among 12 months.  The source data has the 83500, but we would like to allocate it evenly.  However, it should only be done for this one column.

 

Need Help
  • donsvensen's avatar
    donsvensen
    10 years ago

    Hi

     

    You could use the Fill Down transformation and divide the figure with 12

     

    br

    Erik

     

     

7 Replies

  • TAlvarez's avatar
    TAlvarez
    Frequent Visitor
    10 years ago

    Now do you always want this to be divided by 12 always or the number of months you have filtered?

    • Rsanjuan's avatar
      Rsanjuan
      Advocate III
      10 years ago

      always divided by 12 for this one column.  The person is one of many, but she's the only one that needs to have this done. Thanks!

      • TAlvarez's avatar
        TAlvarez
        Frequent Visitor
        10 years ago

        You can do a calculated measure that sums all of the row values.

         

        CALCULATE(SUM(Value),ALL(TableName))/12

  • donsvensen's avatar
    donsvensen
    Skilled Sharer
    10 years ago

    Hi

     

    You could use the Fill Down transformation and divide the figure with 12

     

    br

    Erik

     

     

    • Rsanjuan's avatar
      Rsanjuan
      Advocate III
      10 years ago

      Where is the fill down transformation?  Sorry have not seen this!

       

       

      • donsvensen's avatar
        donsvensen
        Skilled Sharer
        10 years ago

        Hi Rsanjuan

         

        Its on the transform tab

         

         

        /Erik