Forum Discussion
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...
brinky , for % of total you need to Modify a measure like
divide([PY], calculate([PY], allselected(Table)))
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
Thanks for your reply, unfortunately this doesn't wok when using calculations with Tabular Editor.