I created a calculation field with nested aggregate using LAC-A.

But I have an error when saving.

```
We encountered an error trying to save your calculated field. Please try creating it again.
```

Is LAC-A not available in nested aggregates?

I created a calculation field with nested aggregate using LAC-A.

But I have an error when saving.

```
We encountered an error trying to save your calculated field. Please try creating it again.
```

Is LAC-A not available in nested aggregates?

Hi,

Yes currently there are limitations on nested aggregations , details are noted in the documentation : Using level-aware calculations in Amazon QuickSight - Amazon QuickSight

Can you explain regarding the calculation you want for PI : eg item x = (250/2500)*1000 ? or ( 250/1000)*1000

Regards,

Koushik

Hi, Koushik,

Thank you for your response.

Can you explain regarding the calculation you want for PI : eg item x = (250/2500)*1000 ? or ( 250/1000)*1000

I want to calculate PI is as following.

Because Item X is purchased at both stores A and B.

`item x = (250/2500)*1000`

Regards,

Oshida

Hi Koushik,

Yes is it.

In addition to this, I’d like to dynamically filter by the store, product etc. .

Regards,

Oshida

Hi Oshida,

I am not sure if you have seen the following workshop : Workshop Studio

It does guide you in implementing filters in a dashboard.

In the screenshot i posted , the PI calculation was

```
(sum({num_sales})/sum({num_customers}))*1000
```

Kind Regards,

Koushik