Aggr with all dimensions

[#1]

Hi everybody,

I'm trying to show theses tables :

Table 1 :

Names  | Sales |

Name1  | 100       |

...

Table 2 :

Names  | Sales |

Name1  | 200       |

...

Theses two tables are the same except that the first is depending on selections and the second one is for all values

What I have done is this :

Table 1 :

Aggr(sum(sales), Names)

And for the second :

Aggr(sum({1} sales), Names)

But when I selected a dimensions like Country (link to sales not to vendor) the second table is refresh and I have :

Table 2 :

Names  | Sales |

Name1  | 100       |

Anyone can help me please ?

Regards,

Adrian

[#2]

Any help ?

I just want to use the aggr function with excluding selections ..

Thanks

[llauses243]

Hi Adrian,

For is necessary to distinct, then you must to add a new field in script

Adjust solution in image attached and box with green border

Important:  To consider as reference your field Names as Vendedor mine, Sales as Ano & GE as new field

Good luck, Luis

Moreover has others considerations to use AGGR with Chart or Text Object