Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have problem in working with variable...the problem is i have year dimention and i want to show for example profit in the maximum of year selection... it means if I select 2009,2010,2011 , the chart show me Profit of the 2011...
thanx
sahar
Hello Sahar,
Try an expression like the following
Sum({< YearField = {$(=Max(YearField))} >} Profit)
"YearField" is the field that stores all values for year.
Hope this helps.
Hi
I am biginer and tanx a lot for your help... that is working 🙂
best regard
sahar