I have a pivot grid and inside the data area i have 3 columns,
Column 1: Total Quantity
Column 2: Recycled Quantity
Column 3 : Percentage (calculated by the formula (recycled*100)/total)
It show me all the fields, but if i pull the total/recycled quantity from the dataarea, it shows the percentage as 0.
Is there a way to retain the percentage calculation even after the column has been pulled out from the dataager into the filter are or in another possible scenario, is there a way that i can hide column 1/ column 2 / both and just show the percentage
Thank you for your clarification. This behavior is by design. An unbound expression can be calculated only by fields placed in the Data Area. The Filter Area is meant for providing the filtering capability. If you want to hide Data Field, it is necessary to use the Customization Form. We have already discussed this issue in the Unbound expression errors related to hidden fields thread, please refer to it for additional information.