Double aggr ()

[#1]

Hi All

I really need your help!

I have the following aggr in a pivot table:

aggr(max({<INDEX_Activitiy={"ABC"}>} Activities_id),Activities_ancestor_id)

The result is an ID number, lets say 2345.

this ID number, Is a key for additional field. lets say under this ID i have 3 "activities_children_id" (example: 2,5,7).

I want to count the number of "activities_children_id" under the result of the above aggr.

I tried to write the following expression:

aggr(count(activities_children_id),aggr(max({<INDEX_Activitiy={"ABC"}>} Activities_id),Activities_ancestor_id))

but I received a null value and not the required result (3).

Can someone please advise?

thanks!

Attached an example

[PrashantSangle]

Hi,

Try with Only()

Try like,

aggr(count(activities_children_id),Only(aggr(max({<INDEX_Activitiy={"ABC"}>} Activities_id),Activities_ancestor_id)))

Regards

[Anonymous]

Hi,

Please can you upload sample data.

Regards

Neetha

[#4]

Hi

thank you for answering.

I Try to use the expression above but It didn't work. In the text box I get "Error in expression: Nested aggregation not allowed"

[PrashantSangle]

Hi,

Create Variable with 1st aggr

and used that variable in your 2nd aggr()

Regards

[#6]

Hi,

thanks.

that didn't helped also.. I get '-'

[jmmayoral3]

Try this

Count({$< Activities_id = {'= aggr(max({<INDEX_Activitiy={"ABC"}>} Activities_id),Activities_ancestor_id)'} >} activities_children_id)