 Rank: Newbie
Groups: extranet\Forum
Joined: 10/25/2018(UTC)
Posts: 4
|
I have a comparison with about 150 part numbers. How can I put that list in excel so i can see what part numbers are missing? Even just a copy and past all part numbers would be fine.
|
|
|
|
|
|
 Rank: Administration
Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 508
|
Hi Andy,
In TARGIT, if you create a new *Table* object (not *Crosstab*, but simply *Table*), you can add your comparison to that table - without adding any measures.
This should provide a full list of all your comparison members of that comparison - which you then can right click and export to Excel.
Let me know if this will work for you.
BR / Ole |
Ole Dyring |
|
|
|
|
|
Rank: Newbie
Groups: extranet\Forum
Joined: 10/25/2018(UTC)
Posts: 4
|
Originally Posted by: Ole  Hi Andy,
In TARGIT, if you create a new *Table* object (not *Crosstab*, but simply *Table*), you can add your comparison to that table - without adding any measures.
This should provide a full list of all your comparison members of that comparison - which you then can right click and export to Excel.
Let me know if this will work for you.
BR / Ole Good idea. When I added the comparison to the table to the Top I get a message that says "New Table More values must be selected". When I move the comparison to the bottom of table design I get no data. I think I am missing something.
|
|
|
|
|
|
Rank: Administration
Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 508
|
Definitely, the latter option ought to be the right one.
Try right clicking the table: Data -> Include empty members.
And if that one doesn't work, try adding a measure to the table.
Does anything get through at all - or have I totally misunderstood what it is you want to achieve? |
Ole Dyring |
|
|
|
|
|
Rank: Newbie
Groups: extranet\Forum
Joined: 10/25/2018(UTC)
Posts: 4
|
I just tried the "Include empty members" but it was grayed out. I also tried to add another measure but had no data and was still grayed out. No data.
I just have this stored comparison with so many part numbers than I need to copy/paste or export somewhere so i can see which ones are missing with a vlookup or something in Excel.
|
|
|
|
|
|
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.