Calculated Dimension in Pivot with Average function

[#1]

Guys,

Can anyone tell me how can I create a calculated dimension properly?

I have a dimension with the name KIND RO.

I need to add the dimesion Processing Period to my pivot table as a calculated dimension. The calculation will be the average hours of processing period according to each Kind RO.

[rubenmarin · Accepted solution]

Hi Diana, maybe:

Aggr(Avg(Hours), Kind RO)

Sample data or further expanations will be nice if you want something different.