0 Replies Latest reply: Nov 17, 2016 8:14 PM by David Petiot

# Displaying Selected Quarter and Previous Year Quarter in a Graph

Hi

I was wondering how to display values in a Graph bar for the "currently" selected Quarter (i.e. 2016-1) and the same Quarter last year (2015-1)

I have been able to create Expressions to return the values for both periods, in a table object by using the below expressions:

The selection representing the Quarter is based on this field: [Financial Quarter] so current quarter = '2016-1'

The expression: \$(=Max(CRank)) represent the last month of the selected quarter, where CRank is a linear key)

The expression: [CRank]={'\$(=Max(CRank)-12)','\$(=Max(CRank)-13)','\$(=Max(CRank)-14)'} returns all the months corresponding to the previous year quarter.

Current Quarter Selection

Sum([Field])

Previous Quarter:

Sum({\$<[Financial Quarter]=,[CRank]={'\$(=Max(CRank)-12)','\$(=Max(CRank)-13)','\$(=Max(CRank)-14)'}>}[Field])

Both expressions are working properly in the table object, but i cannot use those in a graph object when i need to display a bar graph where the x-axis represent the [Financial Quarter], because it only returns the current selection '2016-1', when i need to return '2016-1' & '2015-1'

So the question is: how can the dimension selection be ignored so both values are displayed?

Thanks,

David.