Dimension categories from Measure

[spicysudhi]

hi

got a measure (% demand) which is derived from other two (forecast and Demand).

In the Dimensions i need one which displays the available %demand values currently (at any perticular filtered level).

for example,
at product level the when i select 20% for demand from the dimension, it should display only parts with demand of 20%. when i see from product group level, it should display the groups that are of 20%demand (not all the groups having parts with 20%demand, should be calculated at group level).

its something like a dimension based on a measure.

regards,
sudhi

 

[DoubleD]

The calculation and categorization will need to occur in your datasource. Then Transformer can use the category field you've created as a dimension.


Pain is stress leaving the body

DoubleD

 

[Soudarsanan]

Hi Sudhi

Have you found a solution for this problem? If so, could you please share the info. with me?

Thanks a lot