ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Field in Field List but Not Source Data (https://www.excelbanter.com/excel-discussion-misc-queries/164400-pivot-field-field-list-but-not-source-data.html)

AP[_2_]

Pivot Field in Field List but Not Source Data
 
Hello, I typically do not use pivot tables and I have inherited one.
There are two fields, Month, and QTR, that are available in the field
list but they are not fields from the source range? I am assuming
there is a way to create a custom field that is a grouping of another,
in this case date, however I cannot seem to find it. I checked the
user formulas and there are none.
Thanks



All times are GMT +1. The time now is 09:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com