6 Replies Latest reply on Sep 28, 2018 10:20 AM by Kathy W

    How do dynamically display a measure value under different dimension value

    Kathy W

      Hi all,

       

      I want to display a measure value under different dimension according to the value.

      below is my sample data:

       

          

      fiscal yearACCOUNT LEVEL 2ACCOUNT LEVEL 3posted amount
      2017-18revenuetest revenue-1000
      2017-18revenuetest revenue 2300
      2017-18expendituretest expenditure5000
      2017-18expendituretest expenditure 2-600
      2017-18rev/exptransfers-1000
      2017-18rev/exptransfers-1000
      2017-18rev/exptransfers500
      2016-17revenuetest revenues-5000
      2016-17expendituretest expenditure2000
      2016-17rev/exptransfers8000
      2016-17rev/exptransfers-1000
      2016-17rev/exptransfers500

       

      When sum of transfers is <= 0 then I want it to be reported under revenue along with other revenue items.

       

      from here I want to display 'transfers' under 'revenue' in fiscal year 2017-18 and it should be under 'expenditure' in fiscal year 2016-17.

      below would be the result data set (in real work I need to create a stack bar chart)

          

      fiscal yearACCOUNT LEVEL 2ACCOUNT LEVEL 3posted amount
      2017-18revenuetest revenue-1000
      2017-18revenuetest revenue 2300
      2017-18revenuetransfers-1500
      2016-17revenuetest revenues-5000
      2016-17expendituretest expenditure2000
      2016-17expendituretransfers

      7500

       

       

       

       

      Thanks.

       

      Kathy