PIVOTBY: Using the Required Arguments Only First, let me show you how to use the PIVOTBY function in its simplest form with just the four required fields.