how to group the data in pivot table

sravanbharadwaj — Wed, 25 Nov 2020 16:16:04 GMT

hi,

i have a data with project names associated with unique id and these projects are associated to some groups for example

ID	project name	group	Sub group	Sub Sub Group
1	abc	group 1	xyz	123
2	efgh	group 1	pqrs	456
3	abc	group 1	xyz	123

i have data like this, now in a pivot table i need to create some calculations there i need id, Cyclic group(Project name,group, Sub group,Sub Sub group....) , Average expressions. i added the dimension as cyclic group and id as link expression and the calculations but there i'm getting data like this

ID	Cyclic group(project name)	Calculation
	abc	12546+4568
2	efgh	120134

Because of same name i'm getting nothing in the id as link(expression) if i use id as dimension i'm able to get all the projects but i'm unable to group them as per the cyclic group. the result if i use id as dimension

ID	Cyclic group(group)	Calculation
1	group 1	12546
2	group 1	120134

1	group 1	4568

but i need to display the data as in second table but i need all individual project names with id's

can any one please help me out

thanks,

sravan

topic how to group the data in pivot table in QlikView

how to group the data in pivot table