Pivot table from Data Model shows entries duplicated for all labels

%3CLINGO-SUB%20id%3D%22lingo-sub-1268382%22%20slang%3D%22en-US%22%3EPivot%20table%20from%20Data%20Model%20shows%20entries%20duplicated%20for%20all%20labels%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1268382%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20creating%20a%20pivot%20table%20from%20the%20Sata%20Model%2C%20I%20am%20having%20the%20issue%20of%20getting%20a%20Pivot%20Table%20with%20repeated%20labels%2C%20that%20do%20not%20belong%20to%20the%20specific%20headings.%20(It%20repeats%20under%20each%20top%20label%20the%20same%20subcategories%20a%C3%B3f%20all%20top%20labels%2C%20not%20the%20ones%20that%20actually%20belong%20to%20each%20of%20them).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20my%20case%2C%20it%20is%20not%20possible%20to%20create%20a%20RELATED%20column%20in%20the%20data%20model%20in%20one%20of%20the%20tables%2C%20because%20entities%20are%20linked%20by%20date%2C%20and%20a%20more%20complex%20network%20of%20relationships.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAdditionally%2C%20the%20links%20are%20created%20between%20all%20tables%20using%20auxiliary%20tables%20with%20unique%20entities%2C%20therefore%2C%20the%20output%20should%20be%20showing%20that%20filter%20alredy%2C%20but%20does%20not%20seem%20to%20recognise%20those%20relationships.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20the%20relationships%20diagram%20(probably%20overcomplicated%20and%20with%20repeated%20info%2C%20because%20I%20have%20been%20trying%20all%20sort%20of%20options)%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Relationships.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F180932i2F7271B08B8D59B7%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Relationships.png%22%20alt%3D%22Relationships.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EBelow%2C%20the%20relationship%20list%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Relationships%20List.png%22%20style%3D%22width%3A%20797px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F180924i9E33A50D93DA2A7E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Relationships%20List.png%22%20alt%3D%22Relationships%20List.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EThis%20are%20the%20fields%20I%20am%20using%20to%20generate%20the%20Pivot%20Table%20from%20the%20Data%20Model%20(The%20yellow%20message%20of%20%22relationships%20are%20needed%22%20pops%20in%20when%20adding%20to%20the%20pivot%20table%20the%20category%20that%20repeats%20in%20all%20labels.%20However%2C%20that%20relationship%20is%20already%20created!!)%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Pivot%20fields.png%22%20style%3D%22width%3A%20688px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F180925iD8F74C88DA159815%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Pivot%20fields.png%22%20alt%3D%22Pivot%20fields.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3EAnd%20this%20is%20the%20pivot%20table%20I%20get%20as%20a%20result%2C%20where%20lots%20of%20entries%20appear%20as%20blank%20in%20a%20category%20where%20they%20don't%20even%20exist%20(all%20labels%20in%20that%20column%20appear%20repeted%20inside%20every%20single%20level%20from%20the%20previous%20category)%3A%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Pivot%20Table.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F180926iD25128F7C41CF7EA%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Pivot%20Table.PNG%22%20alt%3D%22Pivot%20Table.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnybody%20has%20had%20a%20similar%20case%2C%20and%20have%20found%20a%20solution%20or%20a%20way%20around%20already%3F%3C%2FP%3E%3CP%3EHelp%20is%20much%20appreciated!%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1268382%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Contributor

Hi all,

 

When creating a pivot table from the Sata Model, I am having the issue of getting a Pivot Table with repeated labels, that do not belong to the specific headings. (It repeats under each top label the same subcategories aóf all top labels, not the ones that actually belong to each of them).

 

In my case, it is not possible to create a RELATED column in the data model in one of the tables, because entities are linked by date, and a more complex network of relationships.

 

Additionally, the links are created between all tables using auxiliary tables with unique entities, therefore, the output should be showing that filter alredy, but does not seem to recognise those relationships.

 

This is the relationships diagram (probably overcomplicated and with repeated info, because I have been trying all sort of options):

Relationships.png

 


Below, the relationship list:

 

Relationships List.png


This are the fields I am using to generate the Pivot Table from the Data Model (The yellow message of "relationships are needed" pops in when adding to the pivot table the category that repeats in all labels. However, that relationship is already created!!):

 

Pivot fields.png

 

And this is the pivot table I get as a result, where lots of entries appear as blank in a category where they don't even exist (all labels in that column appear repeted inside every single level from the previous category):

 

Pivot Table.PNG

 

Anybody has had a similar case, and have found a solution or a way around already?

Help is much appreciated!

Thanks,

0 Replies