For example, I have Members Table with Surname, First Name and Second Name. Members Table also a formula field Member Full Name which is Surname + Firstname. Pivot tables do not allow for formula fields now I have to create a view with the Surname and Name for Pivot tables. With a virtual field, I could have done a select statement to get the Member Full Name or else Pivot tables must allow for formula fields. Please .. Please !!!!!!