3 Replies Latest reply: Apr 24, 2012 3:39 AM by Ashutosh Paliwal

# problem with all / total

Hello everybody:

I have that rows

año  ventas cliente

2012  10     cl1

2012  20     cl1

2012  40     cl2

2011  15

The year is in a multiple selection object

i need the expression that evalue the total of venta of client1 divide by the total of year

for example  cl1 is 30 /70 for the 2012

but the sum(all ventas) returns 85 and sum({\$<año=>} all ventas) not run.

How i obtain the sum of all ventas for the year that i selected in the multiple selection.

• ###### problem with all / total

Hi,

Kindly tell me which type of object you are using to visualize the data.

So that, it will be easy to give appropriate expressions.

Regards

Andrew Hudson

• ###### Re: problem with all / total

Hi,

Please go through the attachment where i showed the o/p you want.

-yojas

• ###### Re: problem with all / total

Hi,

While It should work as is shown in attached application in previous answer.

You can also try doing it in  by sum(ventas)/sum(total <año> ventas)

the differrence between all and total is that total respects the selections but does not respect the dimensions of the chart but all ignores selecttion as well as dimensions.

If, You want to ignore selections then you can use all.

So, the same way it can be

sum(ventas)/sum(all <año> ventas)

.

Ashutosh