How to pivot based on three fields?
How to pivot based on three fields?
For example, in the screenshots below, I wanted to pivot based on the following fields
To have F1 as rows
To have F2 as columns
To have F4 as values
Currently, it appears that excel has no power to write the values of F4 in the pivot table.
How this can be performed?
Thank you
Jamal
|