Why is the attribute repeatinng for the same article no ?

[Former Member]

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--20---(so on)

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

[Former Member · Accepted solution]

Hi

Plz check property of your lead time : if its been speficaly said "DO not display result"...

Try setting it to " dsiplay Result" and then sum of this..

hope it helps

Gaurav

Assign pts if it helps

[Former Member · Accepted solution]

Hi Gaurav,

Thank you for your suggestion. I've just found out that it's not a KF, it's an attribute of numeric data type. I'e rephrased my question, can you please help me with that. (As i said earlier, i'm relying on a BA's explanation, since they arew orking on my auth's, so i apologize for the wrong explanation)

Thank you...

[Former Member · Accepted solution]

H,

Not sure wht you mean by "attribute of numeric data type".

Did you mean to say tht its Replacement path on characteristics variable??

Anyways pl chk with my earlier suggestion.

Gaurav

Assign pts if it works