Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Thanks in advance.
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
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
Hi,
Please go through the attachment where i showed the o/p you want.
-yojas
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