topic Pivot Table with calculated Fields in App Development

Pivot Table with calculated Fields

Frédéricdh — Tue, 15 Oct 2024 13:52:11 GMT

Hello,

I make a Pivot Table with a dimension, which is a function.. like If(x)

This dimension must be used in an other function, like GetFieldSelections.

WHich is the solution to find the value of the function?

thanks for helping

Frédéric S.

Re: Pivot Table with calculated Fields

Kushal_Chawda — Tue, 15 Oct 2024 14:52:37 GMT

@Frédéricdh Could you provide example of what you are trying to achieve? In general, when you perform selection on pivot table dimension value, it actually applies selection on Field defined in calculated dimension. Hence, you should be able to use GetFieldSelections(Field_name)

Where Field_name is the field defined in the calculated dimension of the pivot table.