Hi Experts... Issue About Trend Period

[vangurideepu]

i want display trend lines for each year, but i got only present year

can anybody help me out.

My achievement like below image..

Thanks in advance

Regards

Pradeep

[Anonymous]

Your data only has one year or when you create it, it only shows one year?

[nagarjuna_kotha]

Hi ,

Check this...

Exp: Sum({<[Order Year]>}Value) (It will exclude year selections )

Script:

LOAD * INLINE [

    Order Year, Month, Value

    2015, Jan, 1383

    2015, Feb, 3451

    2015, Mar, 1570

    2015, Apr, 1730

    2015, May, 1961

    2015, Jun, 3588

    2015, Jul, 2738

    2015, Aug, 3083

    2015, Sep, 1305

    2015, Oct, 3303

    2015, Nov, 2481

    2015, Dec, 1726

    2014, Jan, 3052

    2014, Feb, 1290

    2014, Mar, 3562

    2014, Apr, 3016

    2014, May, 1308

    2014, Jun, 2721

    2014, Jul, 2171

    2014, Aug, 1963

    2014, Sep, 2851

    2014, Oct, 1388

    2014, Nov, 2321

    2014, Dec, 1379

    2013, Jan, 1396

    2013, Feb, 3166

    2013, Mar, 3121

    2013, Apr, 2635

    2013, May, 2709

    2013, Jun, 2810

    2013, Jul, 2765

    2013, Aug, 2698

    2013, Sep, 3562

    2013, Oct, 2834

    2013, Nov, 2603

    2013, Dec, 2477

    2012, Jan, 2687

    2012, Feb, 2175

    2012, Mar, 1523

    2012, Apr, 2941

    2012, May, 1656

    2012, Jun, 1282

    2012, Jul, 3348

    2012, Aug, 1904

    2012, Sep, 3311

    2012, Oct, 3187

    2012, Nov, 1791

    2012, Dec, 1321

    2016, Jan, 3189

    2016, Feb, 3294

    2016, Mar, 2877

    2016, Apr, 1349

    2016, May, 2401

    2016, Jun, 2027

    2016, Jul, 1848

    2016, Aug, 2984

    2016, Sep, 1954

    2016, Oct, 3083

    2016, Nov, 3422

    2016, Dec, 2731

];

[nagarjuna_kotha]

[nagarjuna_kotha]

But As per ur screenshot,

U should take expressions on Year wise , Like

Exp's:

2016: Sum({<[Order Year]={2016}>}Value)

2015: Sum({<[Order Year]={2015}>}Value)  etc.......

and Dimension Should be only on i.e Month

I hop his might helps you.

-Nagarjun

[jagan]

Hi,

What is your expression?  Are you selecting any year in the filter?

Try like this

=Sum({<YearFieldName=>}Sales)

***YearFieldName=, this will ignore Year selection, so it will display all years info.

Regards,

Jagan.

[muthukumar77]

Hi,

Sum({<OrderYear=,OrderMonthName=>}Sales)