Skip to Content
0
Former Member
Apr 07, 2015 at 05:43 PM

when i select 2004 then output should be 2005 years in webi

15 Views

Hi Experts ,

i need a small requirement

Quarter

Year

Sales revenue

Q1

2004

$2,660,700

Q1

2005

$3,326,172

Q1

2006

$3,742,989

Q2

2004

$2,279,003

Q2

2005

$2,840,651

Q2

2006

$4,006,718

Q3

2004

$1,367,841

Q3

2005

$2,879,303

Q3

2006

$3,953,395

Q4

2004

$1,788,580

Q4

2005

$4,186,120

Q4

2006

$3,356,041

When i appying any filter like input control filter on year . exampe: when i select 2004 then output should be 2005 years in webi

Quarter

Year

Sales revenue

Q1

2005

$3,326,172

Q2

2005

$2,840,651

Q3

2005

$2,879,303

Q4

2005

$4,186,120

When i Select 2005 in input control filter and out put should be like this

Quarter

Year

Sales revenue

Q1

2006

$3,742,989

Q2

2006

$4,006,718

Q3

2006

$3,953,395

Q4

2006

$3,356,041

Thanks Dinesh