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
Highlighted
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
Highlighted

@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
HELP TEAMS screen share not
keberly in Microsoft Teams on
6 Replies
Teams Email Not Showing
A-A-Ron321 in Microsoft Teams on
3 Replies
Files in private channels for guest users
Hugo_CF79 in Microsoft Teams on
3 Replies
TEAMS notifications
KasiK2460 in Microsoft Teams on
0 Replies