Change expression according with dimension value on pivot table

[#1]

Hello everyone:

I have a pivot table, and I need to change the formula expression according with Dimension Value. I mean when Dimension value on Pivot table is "HEADCOUNT" I need to Calculate the average, instead of SUM like others dimensions.

Any idea will be appreciate.

Thank you

[swuehl · Accepted solution]

Maybe you can use something like

=If( DimensionField = 'HEADCOUNT',

    Avg ( Value),

   Sum(Value)

)

[#3]

Thank you.

My best regards