Question (show multiple descriptions)

[#1]

Hello,

Need some help:

i have a column with article number and a column with a description.

It can be that an article have 2 different descriptions.

Is it possible to create a table that shows if there are 2 descriptions:

Article A    description1

                 description2

Article L    description1

                 description2

art. Nr	descr.
2000091733380	6201930000 6104630000
2000091733397	6207110000 6109100090

[Anil_Babu_Samineni]

I may not fully understand the intend, Would it possible to explain the result set you required. That may help us to think on fly

[marcus_sommer]

You could use [art. Nr] as dimension and count(distinct descr.) and concat(distinct descr., ' + ') as expressions in a table-cahrt and maybe also a calculated dimension within a listbox like: aggr(count(distinct descr.), [art. Nr]) to be able to filter them.

- Marcus

[Peter_Cammaert]

Or simply use a Table Box to list all active article nmubers and their linked descriptions.

[#5]

Now I have :

if I expand all both description are visible:

But I want to see in the first Collapsed situation 2 or other ??  so I can find the double descriptions. It's a list with +50K records. So impossible to find everything just by scrolling.

[#6]

Now I have :

if I expand all both description are visible:

But I want to see in the first Collapsed situation 2 or other ??  so I can find the double descriptions. It's a list with +50K records. So impossible to find everything just by scrolling.