We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
close icon

Hiding of pivot item

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



            <syncfusion:PivotGridControl.PivotCalculations>
                <syncfusion:PivotComputationInfo Description="Summation of Unit Price" FieldName="UnitPrice" FieldHeader="Unit Price" Format="C" SummaryType="DoubleTotalSum"/>
                <syncfusion:PivotComputationInfo Description="Summation of Amount" FieldName="Amount" Format="C" SummaryType="DoubleTotalSum"/>
                <syncfusion:PivotComputationInfo Description="Count of Quantity" FieldName="Quantity" Format="#,##0" />
            </syncfusion:PivotGridControl.PivotCalculations>           



Loader.
Up arrow icon