Hiding of pivot item

Thread ID:

Created:

Platform:

Replies:

Hello,Say I have 3 columns (like in pivotgridexpressionfielddemo) Amount, Quantity and UnitPrice (Amount/Quantity) . I have two questions , is it possible to a) Hide Amount and Quantity (I just want to show UnitPrice ie CalculatedColum)b) Is it possible to use if statement, like If (Amount >500,1,2) , if yes, can you please share the syntax