Fiscal year into year graph

[#1]

Hi all..

I have three field

fiscal year/financial year

month

year

suppose select fiscal year 2014-2015

I have created a graph as fiscal year as dimension so 2014-2015 has arrived on x-axis

with the expression sum(bill_amount)

now......................

I want to show two more graphs with the dimension year and month like as follow

1st: with 2014 on x-axis with month includes july-2014 to dec-14 and sum of all bill amount in 2014 in expression

second: with 2015 on x-axis showing month included jan-15 to jun-15 and billing amount of 2015 as expression

plz advice

[#2 · Accepted solution]

i have done it.....

define first graph dimension as left(fiscalYear,'4') and 2nd graph dimension as right(fiscalYear,'4')

thnks.....