fiscal year

[Anonymous]

hello everyone

i have one requirement, i want to show Q1,Q2,Q3,Q4 in a different chart and Q1,Q2,Q3,Q4 in a single chart(fiscal year) (it means total 5 chart)

i have fiscal year from 2010 to 2015 . my issue is while i select single year then it shows in a  5 charts but when i select 2 year simultaneously then it shows 2 years data in 4 chart  but not in single chart(fiscal year).

when i select single year

when i select 2 year simultaneously

Thank you.

[Mark_Little]

Hi,

Can you please share your expressions used.

I am guessing your deimension is your Quarter field, but not knowing the set analysis used in the expression we won't be able to advise what is wrong.

Mark

[Anonymous]

sorry but i cant share it.

i am taking fiscal quarter as a dimension and in expression used if condition

[shanky1907]

Can you take Year as dimension also in the chart and check?

[Mark_Little]

If you can't share your calculation then i won't be able to tell you what is wrong with it.

I am not asking for any data, just evening if you change the field names so we can see the syntax.

Something like

IF(Value =1,SUM(Amount))

Mark

[Anonymous]

but it show data only for 1st year

[avinashelite]

In both the charts your using the same Fiscal Quarter?? or calendar   Quarter quater in one chart ??

[avinashelite]

whats the expression for both the charts ?? same or different