Need Bar Graph help

[ananyaghosh]

Hi,

I need to create a bar graph and have to use year as dimension, but need to largest two year in dimension and have to use summation of Income and Expense as expression.

Please suggest what to do in dimension and expression?

thanks,

Sandip

[Gysbert_Wassenaar]

See attached qvw.

[Anonymous]

Like this?

[buzzy996]

try tis,

set ur dimenions as year in dimenion table,

set ur expressions,sum(exp) ,sum(income) on expression tab,ur 2 expressions,

on dimenion limits tab just set largest as 2,uncheck other from bottom if u don't want.

[ananyaghosh]

Hi,

It is straight table. But I want to show a bar graph. So if i am trying to create a bar graph no data is showing. Please help me to make  a bar graph.

[ananyaghosh]

I did not see the largest two values in your graph. The largest two values of year should be 2015, 2014, but if I am restrict the values of two in limit dimension tab, it shows the wrong value.

[anbu1984]

Check this app. Largest two years are 2014 and 2012

[ananyaghosh]

In my Attached excel sheet 2015 and 2014 are the largest two years. But it is now showing your app. So what to do now. Please suggest.

[anbu1984]

Check the Straight table in my app. I am getting the same values for 2015 when I sum them in your excel.