Setting an object equal to 1000

Hi Rocco,

what do you mean by aggregated level ?

@Nathan I would like to set an object with multiple dimensions (5 dimensions) to be equal to 1000 

Those 1000 should be spread down by the dimensions.
Is it possible with a formula?

You can do like this (in concept):

10000by split:dimension1,dimension2] 

that’s going to equally split the value over each items of the dimensions.

You can do more elaborate logic of course as needed

I would like all these cells to be equal to the number set, 

could you please help me make it work?

I would like all these cells to be equal to the number set, 

could you please help me make it work?

 

@Nathan 

If you want to see 1000 everywhere, just type 1000 in the formula.

Hi @Rocco 

Please follow below Steps:

1. Create a metric (Data Type: Number, Dimensions: No Dimension) and provide input value 1000

2. Create a metric (Data Type: Number, Dimensions: Country, Cost Center, Month,Account) and Write in Formula Bad 

   AmountnAdd Split:Country,'Cost Center']'Add:Account,Month]

   

   Hope this will help you to achieve your requirement.

@Rocco @abhilashsawla is right, ADD is the right keyword , not BY