4 Replies Latest reply: Jul 4, 2017 7:12 PM by Sunny Talwar RSS

    Dimensional value split into multiple column in Table view?

    Devarasu R

      Hi,

       

      Can you advise me on how to show below expected output using Straight table? Thanks

       

      Capture.JPG

      I've tried below set expression and it's not getting desired output like above.

      sum({<Shop=P({<Shop={'Warehouse'}>}Product)>}SOH)

      //sum( {$<Shop = P({1<Shop={'Warehouse'}>})>} SOH )

      //=SUM( {<Category = P({<Category ={'WHS'}>} ) >}  SOH)

      //sum({<Category={'WHS'}>}SOH)

      //sum({<Shop={'Warehouse'}>}SOH)

       

      Thanks,

      Deva