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
