Forum Discussion

brinky's avatar
brinky
Icon for Helper IV rankHelper IV
5 years ago
Solved

Market Share using Tabular Editor

Good morning,

 

Any idea how to create a caclculation on Tabular Editor to get MARKETSHARE as per attached excel sample file.

 

My other calcluations listed below work like a charm, thanks to Marco Russo's video.

 

Need Help
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    5 years ago

    brinky , for % of total you need to Modify a measure like

    divide([PY], calculate([PY], allselected(Table)))

4 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    brinky , for % of total you need to Modify a measure like

    divide([PY], calculate([PY], allselected(Table)))

  • negi007's avatar
    negi007
    Icon for Community Champion rankCommunity Champion
    5 years ago

    brinky You can use your already created PY, PM and Current to calculate share% from total. You drag these measures in the value field and right clicking will allow you to change the values into % of grand total which is basically the share% from total

     

     

    • brinky's avatar
      brinky
      Icon for Helper IV rankHelper IV
      5 years ago

      Thanks for your reply, unfortunately this doesn't wok when using calculations with Tabular Editor.