Excluding Month and Quarter in Aggr

[#1]

Hi All,

I am using the below aggr in a pivot able and needs to modify the formuala to exlcude the selection of Month and Quarter. Please could you adivse.

Formuala.

Aggr(sum(IPN),CLI)

Thanks,

Sijo Joseph

[Gysbert_Wassenaar]

Aggr(sum({<Month,Quarter>}IPN),CLI)

[#3]

Thanks,

I tried this is working when only set analysis but not with aggr.

Thanks,

Sijo