Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
My requirement is when user click year 2012 he want to see 2008 data(sales) in straight table for this i wrote exp: Sum ({$<Year={$(=(Year)-4)}>}Sales)
this is working fine but user wants with out selecting year he wants to show all years data in Straight table
Please i need your assistance
Thanks in Advance
Nihhal
Hi
try
if(getselectedcount(Year) <> 0 , Sum ({$<Year={$(=(Year)-4)}>}Sales), Sum(Sales))
Hi
try
if(getselectedcount(Year) <> 0 , Sum ({$<Year={$(=(Year)-4)}>}Sales), Sum(Sales))
Could you upload a sample application ?
Hi,
create a chart with Year as the dimension and =Sum (Sales) as the expression.
Hope this helps.
Thank You Alexis Tan
NiHhal.