Percentages of whole table instead of dimensions

[#1]

Hi All,

I have the following table:

Length	Waist	30	31	32	33	34	35	36	38	40
32		50% (2 / 4)	67% (2 / 3)	70% (7 / 10)	58% (7 / 12)	60% (6 / 10)	100% (1 / 1)	90% (9 / 10)	0% (0 / 1)	(0 / 0)
34		0% (0 / 1)	40% (2 / 5)	44% (4 / 9)	36% (4 / 11)	40% (4 / 10)	0% (0 / 1)	80% (8 / 10)	67% (6 / 9)	0% (0 / 1)
36		(0 / 0)	(0 / 0)	0% (0 / 1)	0% (0 / 1)	0% (0 / 2)	0% (0 / 1)	0% (0 / 1)	(0 / 0)	(0 / 0)
38		(0 / 0)	(0 / 0)	(0 / 0)	(0 / 0)	(0 / 0)	(0 / 0)	(0 / 0)	0% (0 / 1)	(0 / 0)

As you can see the percentages are based on the sum next to it, which is amount sold / amount delivered.

I want the percentage to be calculated as the amount sold against the TOTAL amount delivered. Any Idea on how to do this?

[sunny_talwar]

May be like this

Sum(Sold)/Sum(TOTAL Delivered)

[#3]

Thanks! This sort of works. Problem is, it calculates over everything, not seperated by dimension. For example. As a Dimension I also have customers. Now I need to calculate the totals per customer, not all.

[pho3nix90]

HI Maarten,

Could you please add an example qvw. The data you pasted in your original post is extremely hard to read

[sunny_talwar]

Try this:

Sum(Sold)/Sum(TOTAL <Customer> Delivered)