Adding rows and allocating total for one column

[Rsanjuan]

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.

[donsvensen · Accepted solution]

Hi

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

br

Erik

[donsvensen · Accepted solution]

Hi

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

br

Erik

[Rsanjuan]

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

[donsvensen · Accepted solution]

Hi Rsanjuan

Its on the transform tab

/Erik

[TAlvarez]

@donsvensen

Didn't even consider that, thx learned something new today.

[TAlvarez]

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

[Rsanjuan]

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]

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

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