1 Reply Latest reply on Feb 6, 2019 3:03 PM by Patrick A Van Der Hyde

    Can we put measures on both rows and columns in crosstab?

    sanju d

      Hi All,

       

      Below is my data. and the Output result which I wanted to develop.

       

      I have 2 dimension Account 1 and Account 2.

      In the Output the fields from Total Sales is calculated from 2 different Dimensions ie Total Sales (External Sales+ Internal Sales). So I created a calculated field for this.

       

      In the Output the QTD is the quarter to date and QTPQ is the Quarter to previous quater and QTPYQ is Quarter to Previous year Quarter.

      Sp right now in the output from External sales to Salary is Dimensions and Total sales to Total Expense is Calculated field which is measure.

      Even the QTD, QTPQ and QTPYQ is a measure field.

       

      When I place the Total sales calculated field in the Row in the crosstab it doesn't show me the exact values for QTD etc,

       

      Kindly help.

         

      Account 1Account 2DollarDate
      External SalesInternal Sales102017 Q4
      ProfitBonus202017 Q4
      ElectricityWater302017 Q4
      MaintainenceSalary402017 Q4
      External SalesInternal Sales102018Q4
      ProfitBonus202018Q4
      ElectricityWater302018Q4
      MaintainenceSalary402018Q4
      External SalesInternal Sales102019Q1
      ProfitBonus202019Q1
      ElectricityWater302019Q1
      MaintainenceSalary402019Q1

       

       

      Result

        

      CategotyQTDQTPQQTPYQ
      External Sales
      Profit
      Electricity
      Maintainence
      Internal Sales
      Bonus
      Water
      Salary
      Total Sales (External Sales+ Internal Sales)
      Total Bonus (Profit + Bonus)
      Total Bill (Electricity + Bill)
      Total Expense (Maintainence  + Salary)