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 Mar...
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)))

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)))

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

    Thanks, amitchandak worked as required and as expected. 👏

     

    Thank You