RPD Formula

Question

Hello,

I would like to create a formula in the RPD that does the following:

Units Per Hour / QUATITYPERHOUR for the CustID & Category & UOM

I am not sure how to go about this so any ideas would be welcome. I have attached what the data currently looks like.

SriniVEERAVALLI · Answer

In Criteria tab we can go for aggregate something like sum(Measure1 by Col1) or sum(Measure1 by Col1,Col2)

bskumar.obiee · Answer

Did you mean.. aggregate based on dimensions?? If so, please refer the below article..

https://gerardnico.com/wiki/dat/obiee/obis/aggregation_based_on_dimension

Ed Chavez · Answer

I don't know if this what you are asking, let me know.