SOLVED
Home

Creating Specific Pivot Table format

%3CLINGO-SUB%20id%3D%22lingo-sub-826308%22%20slang%3D%22en-US%22%3ECreating%20Specific%20Pivot%20Table%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-826308%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHi%2C%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EI%20have%20a%20database%20collecting%20all%20my%20production%20data%20from%20a%20factory%2C%20and%20I%20would%20like%20to%20produce%20a%20pivot%20table%20that%20mimics%20my%20production%20report%20-%20to%20make%20things%20more%20efficient%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EI've%20tried%20many%20approaches%20but%20I%20am%20no%20expert%20in%20Pivots%2C%20therefore%20got%20stuck.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3ELink%20to%20the%20sheet%20with%20the%20Data%20and%20Desired%20outcome%20can%20be%20found%20below%2C%20any%20help%20would%20be%20hugely%20appreciated%20!!%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3ENote%3A%20I%20am%20filling%20the%20data%20in%20a%20way%20where%20my%20production%20is%20recorded%20on%201%20line%20and%20then%20all%20my%20consumables%20are%20on%20the%20lines%20below%2C%20with%20the%20some%20data%20repeated%20for%20pivot%20to%20pick%20up.%20You%20might%20find%20this%20incorrect%20and%20I%20could%20change%20the%20data%20capturing%20method%20based%20on%20any%20suggestions%20here.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EThanks%20in%20advance%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3ELuka%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CA%20title%3D%22Excel%20Pivot%20Requirement%22%20href%3D%22https%3A%2F%2Fwww.dropbox.com%2Fs%2Fcpfyuiqsv7gxp6p%2Ftest.xlsx%3Fdl%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ELink%20to%20Document%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-826308%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPivot%20tables%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-826423%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20Specific%20Pivot%20Table%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-826423%22%20slang%3D%22en-US%22%3E%3CP%3EOkay%20so%20i%20solved%20this%20using%20Pivot%20Table%20DAX%20Functionality%3C%2FP%3E%3CP%3ELink%20below%20for%20reference%3C%2FP%3E%3CP%3E%3CA%20title%3D%22DAX%22%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DIiFzVInI5sg%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DIiFzVInI5sg%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Luka84
New Contributor

Hi,
I have a database collecting all my production data from a factory, and I would like to produce a pivot table that mimics my production report - to make things more efficient
I've tried many approaches but I am no expert in Pivots, therefore got stuck.
Link to the sheet with the Data and Desired outcome can be found below, any help would be hugely appreciated !!

Note: I am filling the data in a way where my production is recorded on 1 line and then all my consumables are on the lines below, with the some data repeated for pivot to pick up. You might find this incorrect and I could change the data capturing method based on any suggestions here.
Thanks in advance
Luka

 

Link to Document

1 Reply
Solution

Okay so i solved this using Pivot Table DAX Functionality

Link below for reference

https://www.youtube.com/watch?v=IiFzVInI5sg

Susan in Melbourne wants to create a pivot table that shows text in the values area. Typically, this can not be done. But it is possible with the DAX formula language. Format as Table using Ctrl+T Insert, Pivot Table, Add This Data to the Data Model Build the Row & Column Areas Right-click the ...
Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies