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
Highlighted
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
Highlighted
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...
Related Conversations
Is it possible for Edge to play HEVC (H265) MKV files ?
HotCakeX in Discussions on
2 Replies
Counting Days
Tim Hunter in SQL Server on
2 Replies
PivotTable : Unexpected behavior with 2 tables
CastyChichi in Excel on
2 Replies
Set Auto Refresh to Pivot Table as Source Data Changes
ratishkp in Excel on
2 Replies
Problem sorting Pivot Table according to date
MikkoS in Excel on
1 Replies