
Calculate Dimension Total as Percentage of Grand Total
Jason Michaelides Apr 13, 2012 9:22 AM (in response to Steve Ferson)Hi,
Read the F1 help for Set Analysis and you'll see how much is possible!! For your specific solution, try:
=Sum(Volume)/Sum({1} Volume)
or
=Sum(Volume)/Sum({<Widget=>} Volume)
The first of these will divide the Sum(Volume) for all the current selections by the TOTAL Sum(Volume) when ignoring ALL selections, the second will only ignore the Widget selection.
Hope this helps,
Jason

Calculate Dimension Total as Percentage of Grand Total
Steve Ferson Apr 13, 2012 9:35 AM (in response to Jason Michaelides)Thanks Jason and Celambarasan  that's exactly what I was looking for. Many thanks for the quick response.


Calculate Dimension Total as Percentage of Grand Total
Celambarasan Adhimulam Apr 13, 2012 9:26 AM (in response to Steve Ferson)Hi,
You can do that.
Below expression won't consider selection(divide by all the widgets) to divide
Sum(Volume)/Sum({1} Volume)
Sum(Value)/Sum({1} Value)
Below is to get percentage in the selection
Sum(Volume)/Sum(TOTAL Volume)
Sum(Value)/Sum(TOTAL Value)
Multiply with 100 which gives you percentage or Check the Show in percentage option in the number tab
Celambarasan

Re: Calculate Dimension Total as Percentage of Grand Total
Milad Toliyati May 20, 2015 11:26 AM (in response to Celambarasan Adhimulam )I tried all of these, but it only shows the right ratio in the total section of my table. In front of each row it shows 100%
What can I do?
