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

    Displaying Selected Quarter and Previous Year Quarter in a Graph

    David Petiot

      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.