De-attatching

[#1]

Dear All,

I have show purchasing history in dashboard thorugh graph and year_id as list box.

i also want to show current stock position on same dashboard....

but prblem is that stock is current dont have any concern with past years....

so if I select any year (e.g 2009) then purchasing history working fine but stock is also changing acordingly which

are not required.

Is there any way that if user select any year only purchasing details shld chage not stock details.

if I go with de attatching option . i am also unable to dril with in the stock detail..

thnks........

[lironbaram · Accepted solution]

yes use set analysis

in your stock expression use something like

sum({<Year=>}QuantityInStock)

that way the expression will diregard any selection in the year field

[#3]

Absolutly Perfect .... thnks Liron