Data conversion using Textlist

Question

I have the following data format in transaction list:

Account Name/code	Account Code	Quarter	Product Name	Deal Forecast	Amount
ABC	abc	Q2 FY 26	Tupperware	Closed	1000
ABC	abc	Q3 FY 26	Tupperware	Ommited	2000
PQR	pqr	Q4 FY 26	Coke	Closed	3000

I wish to have a output view as below

Account Name	Account Code	Product Name	Quarter	Deal Forecast	Amount
ABC	abc	Tupperware	Q2 FY 26, Q3 FY26	Closed, Ommited	1000,2000
PQR	pqr	Coke	Q4 FY26	Closed	3000

Thanks in advance for help

Rushi · Answer

Hi, i have derived the answer,We need to create metrics for arriving the view as in Quarter, Deal Forecast and Amount ColumnFor Quarter and Deal Forecast, we can easily arrive by Textlist, for amount column, we need to additionally -use the modifier - remove textlistLater on we need to combine this into a table - the prior columns can be an attribute of account dimension

Ask your question here!

Not finding what you're looking for?

Sign up

Single Sign-On Need help?

Log into the Pigment Community

Single Sign-On Need help?

Scanning file for viruses.

This file cannot be downloaded