Why is the attribute repeatinng for the same article no ?
Dear Experts,
In one of the queries that i've created, the requirement is to use this attribute Leadtime which is of Numc data type. This is an attribute of an Charateristic Article No. Anyway, when i executed the report, with this leadtime in columns, along with other KF's. The result set had too many columns that when i tried to export it to Excel, i got a msg that there are too many cells.
It looked something like this:
Leadtime 10--
10
10
KF1----
KF2
Article no: 123--
333--
444
Overrall Result--
333--
444
So i tried moving Leadtime to rows, the result set looked like this:
Article no----
-Leadtime
- KF1----
KF2
123--
10
333
444
123--
10
555
555
Overrall Result--
888--
999
However we want Leadtime to show up only once for each item, like for ex: for article 123 the leadtime is 10, I'm not sure why this is repeating. as Article 123 10 and then the next line for the same article 123, the leadtime is 10.
Can you please suggest how do i correct this, based on your suggestions, i'll approach our business.
Thank you.
Message was edited by:
NewYorker