7 Replies Latest reply on Apr 22, 2018 11:28 PM by Elmurat Bavlankulov

    How to show dimension as additional column to Measure Names columns

    Elmurat Bavlankulov

      Hello All,

       

      I have a simple question.

      In my table I have Products, Quantities, Profits and States. Please see below copy from Excel.

      So first two column will show Quantity and Profit for each product, and for the next columns I need to show from which states were the orders from and their percentage share on Total Profit for this product.

       

      QuantityProfitProfit %Profit %Profit %Profit %Profit %Profit %Profit %Profit %Profit %
      Product NameTotalTotalState 1State 2State 3State 4State 5State 6State 7State 8State 9
      Product Name 1624,7770%21%0%34% 27%14%3%
      Product Name 2781,4757%6%1%0%18%0%13%53%2%
      Product Name 3174,4310%20%0%1%21%0%39%15%4%
      Product Name 4434,3592%14%1%49%0%0%23%8%3%
      Product Name 5243,95860%12%1%0%0%1%10%12%5%
      Product Name 6774,7312%48%0%40%0% 2%0%7%
      Product Name 7782,5120%49% 1% 41%0%1%8%
      Product Name 8103,56411%19%2%1%49% 12%1%6%
      Product Name 9254,0190%49%3%1% 19%12%14%2%
      Product Name 10991,837 9%0%34% 52%3%3%
      Product Name 11353,733 20%0%1%0%28%30%17%4%
      Product Name 12874,7671%40%0% 1%0%53%0%4%
      Product Name 13833,27811%1%1% 1% 5%78%4%
      Product Name 14304,7860%24% 32%2% 32%5%5%
      Product Name 15382,7453%18%0%0%0%25%40%9%4%
      Product Name 16614,6880%27%1%41%1%1%10%12%5%
      Product Name 17861,307 28%1%31%1%0%34%0%4%
      Product Name 18972,252 23%0% 19% 28%27%2%
      Product Name 19254,1230%19%0%32%0% 36%6%7%
      Product Name 20243,1052%11%0%1%17%0%56%13%2%

       

      Thanks in advance for your answers.