Trying to create a report showing percentage of customers buying a SKU by business chain

[#1]

As the title says, I am trying to create a report that looks something like this:

			SKU1	SKU2	SKU3
business chain A		cases	200	130	140
(total 5 customers)		number of buying customers	4	2	3
		% buying	80	40	60
business chain B		cases	190	210	120
(total 8 customers)		number of buying customers	6	4	6
		% buying	75	50	75
business chain C		cases	300	350	500
total 10 customers		number of buying customers	3	6	7
		% buying	30	60	70

Clearly most of it is straightforward. The bit I am having problem with is the % buying. The calculation needs to be the number of customers buying a SKU divided by the total number of buying customers for the business chain. Has anyone successfully tackled this sort of problem before?

Thanks in advance.

[#2 · Accepted solution]

What is your formula for number of buying customers?

If it's something like Count(Customers), then use:

Count(Customers)/Count(TOTAL <BusinessChain> Customers)

The TOTAL in the denominator means to ignore all dimensions. The two fields in the brackets mean to respect that dimension. Basically, that gives you the number of buyers divided by the total number of customers for that particular BusinessChain (or whatever your Business Chain field is called).

[#3]

wow. I did not know that! (obviously). Very nice and very simple. Thank you!