Trying to select only certain values in calculated expression of pivot table.

[#1]

Hi community,

I was wondering if there was a way to select only certain values of a column in a pivot table.  The expression for that column is something like "if another column in the table is greater than a certain amount, then 1 else 0."  Any help would be appreciated.

[v_iyyappan]

Hi,

Can you please share sample file for that? 

Regards,

[Gysbert_Wassenaar]

You can't select expression values in a pivot table (or any other object). What that will do is select the dimension values of that row.

[abeyphilip]

Hi Brandon,

As G Wassenaar suggested you will not be able to select values of an expression.  However, you can achieve the same by creating a list box with field as expression similar to the one you were selecting in the pivot.

"if another column in the table is greater than a certain amount, then 1 else 0."

For this you will have to include the expression for the "another column" and the evaluate it to 1 or 0. List box will then have two entries 1, 0 and selecting the same will give you the result same selecting the expression value on pivot.

Regards,

Abey

[sathishkumar_go]

HI Brandon,

Please find the attached file.

I hope the attched file will match your requirement.

Regards

Sathish