Table Modify Structure

[adityapavan18]

I have a query which results in following data

But i need to generate a table in this format

[imrago · Accepted solution]

You could use chart instead of table

... | chart sum(TxDuration) over ProductID by Tier

http://docs.splunk.com/Documentation/Splunk/latest/SearchReference/Chart

[adityapavan18]

productID, TxDuration, Tier are three fields

[adityapavan18]

sorry images not uploaded properly..

I have a query which results in following data

ProductID txnDuration Tier

---

1 0.12 Tier_1

---

1 0.14 Tier_2

---

1 1.25 Tier_3

---

2 0.56 Tier_1

---

2 0.89 Tier_2

But i need to generate a table in this format

productID Tier_1 Tier_2 Tier_3

---

1 0.12 0.14 1.25

---

2 0.56 0.89

Can any one help me here please.