Forum Discussion

brinky's avatar
brinky
Helper 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
    Super 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
    Community 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
      Helper IV
      5 years ago

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