Home

pivot table field settings product

%3CLINGO-SUB%20id%3D%22lingo-sub-757616%22%20slang%3D%22en-US%22%3Epivot%20table%20field%20settings%20product%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-757616%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20created%20a%20spreadsheet%20-%20I%20have%20a%20pivot%20table%20completed%20showing%20dates%20in%20the%20values%20column%20by%20choosing%20the%20value%20field%20%22product%22%20under%20field%20settings.%26nbsp%3B%20I%20created%20a%20new%20pivot%20table%20using%20the%20same%20data%20so%20I%20could%20add%20a%20%22add%20measure%22%20column%20because%20I%20didn't%20know%20that%20option%20existed%20when%20I%20created%20the%20first%20pivot%20table.%26nbsp%3B%20NOW%20when%20I%20try%20add%20the%20date%20information%20I%20do%20not%20have%20a%20%22product%22%20option%20under%20the%20date%20field.%26nbsp%3B%20I%20have%20a%20%22distinct%20count%22%20which%20is%20different%20than%20the%20other%20pivot%20table%20options%20-%20but%20I%20need%20the%20%22product%22%20option%20to%20show%20the%20actual%20date.%3C%2FP%3E%3CP%3EWhat%20is%20happening%3F%20What%20am%20I%20doing%20wrong.%26nbsp%3B%20I%20am%20thrilled%20I%20can%20now%20show%20text%20in%20the%20values%20column%20by%20using%20the%20%22add%20measure%22%20but%20I%20need%20the%20date%20to%20show!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-757616%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-757884%22%20slang%3D%22en-US%22%3ERe%3A%20pivot%20table%20field%20settings%20product%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-757884%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F377228%22%20target%3D%22_blank%22%3E%40lmonahan91%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWith%20adding%20data%20to%20data%20model%20you%20have%20no%20Product%20option%20in%20Value%20Field%20setting%2C%20but%20you%20have%20much%20more%20flexibility.%20In%20particular%2C%20you%20may%20add%20your%20own%20measure%20like%3C%2FP%3E%0A%3CPRE%3EDataProduct%3A%3DPRODUCT(%5BData%5D)%3C%2FPRE%3E%0A%3CP%3Eand%20use%20it.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
lmonahan91
Occasional Visitor

I have created a spreadsheet - I have a pivot table completed showing dates in the values column by choosing the value field "product" under field settings.  I created a new pivot table using the same data so I could add a "add measure" column because I didn't know that option existed when I created the first pivot table.  NOW when I try add the date information I do not have a "product" option under the date field.  I have a "distinct count" which is different than the other pivot table options - but I need the "product" option to show the actual date.

What is happening? What am I doing wrong.  I am thrilled I can now show text in the values column by using the "add measure" but I need the date to show!

1 Reply

@lmonahan91 

With adding data to data model you have no Product option in Value Field setting, but you have much more flexibility. In particular, you may add your own measure like

DataProduct:=PRODUCT([Data])

and use it.

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies