8 Replies Latest reply: Apr 23, 2015 1:38 AM by Abinesh Sathish

How to find the total of my current selection year

Dear friends,

How can I find the total of sale value in a current selection of year

Eg:

Sales of value in 2003 incase if I change the year into 2004 it will automatically change itself

Pls send it an expression

• Re: How to find the total of my current selection year

I have detail like as below

year           salesvalue

2001            4563878.12

2003             78945.123

2005             789456

.2002            5487961.32

2001             896564.2

2003            4565832.1

2005            54879386.1

And I need total no of sales value for a particular year. if I select 2001 means it will reply the total of sales value from 2001 if I click 2003 means It returns total value of 2003

That's is it . I need this result in an expression...

• Re: How to find the total of my current selection year

sum(salesvalue) should work

• Re: How to find the total of my current selection year

And more over I used this simple exp.

=sum([Sale value])

It perform correctly but i want to know there is  any other exp available for this scenario to make it more efficiently tat y am asking.......

• Re: How to find the total of my current selection year

Hi,

You can also write like

Sum({<Year={"\$(=max(Year))"}>}[Sale Value])

By default it will give you result for max(Year) else it will give on selection.

Regards

• Re: How to find the total of my current selection year

Max I got my expected expression thank you very much

• Re: How to find the total of my current selection year

'KISS' is the best way..;)

• Re: How to find the total of my current selection year

Robert u r very helpful to me and am surfing the word 'KISS' in google it  give me lot of ideas thank you