Set Analysis, To Display All Years

[nihhalmca]

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

[#2 · Accepted solution]

Hi

try

if(getselectedcount(Year) <> 0 , Sum ({$<Year={$(=(Year)-4)}>}Sales), Sum(Sales))

[senpradip007]

Could you upload a sample application ?

[salto]

Hi,

create a chart with Year as the dimension and  =Sum (Sales) as the expression.

Hope this helps.

[nihhalmca]

Thank You Alexis Tan

NiHhal.