Accumalation based on partial field names

[tahirkhalil]

Hi all,

I am stuck up in one project - I need to sum up based on partial field names, I have following three basic KPIs

1. PRO-Proposition

2. PLN-Planogram

3. SOS-Share of Shelf

I have all three fields for different product lines like Haircare, Skincare, Beverages etc. I got total 10 product lines and 3 KPIs which makes total 30 fields. Now, I have to present the accumulated/Sum of all three KPI based on Product Line like:

Product Line	KPI	Performance
Haircare	PLN	12
	PRO	23
	SOS	10
Beverages	PLN	11
	PRO	10
	SOS	13
Skincare	PLN	10
	PRO	9
	SOS	11

How can I achieve that?

I have attached sample data for your reference.

I have attached again as it was found missing during post.

Regards,

Tahir

Message was edited by: Tahir Khalil - Sample Data File Attachment Missing

[alex_millan]

Are you sure that would do the trick? In some cases, the amount of data will not diminish dramatically, what's more, the difficulties to exploit this data will boost.

Perhaps, if the number of rows is an issue, you may go for a different approach trying to accumulate the data to the desired point in the script.

Hope that helps.

Cheers

[tahirkhalil]

Can you please have a look - I have created a sample data.

I have created another table containing definitions - but the point it is selection based view - can we dig out more with this approach?

[PradeepReddy]

Try some thing like this.. see the attachmen !t...

If it did not caters your requirement, post the output what u want..!!

Thanks,

Pradeep

[tahirkhalil]

Thanks Pradeep !

But again, I dont want crosstab functionality due to higher number of rows.