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:
Article no: 123--
So i tried moving Leadtime to rows, the result set looked like this:
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.
Message was edited by: