Percentage Pivot table

[#1]

Hey, everyone!

I'm trying to solve this issue, but it's not working. see:

I have a Pivot table, where I have the total produced by machine and by product

	Machine A	Machine B	Machine C	Total Per Product
Product A	59	47	79	185
Product B	27	52	22	101
Product C	26	12	55	93
Total Per Machine	112	111	156	379

I want to show the respective percentage for each one of these (like that below):

	Machine A	Machine B	Machine C	Total Per Product
Product A	32%	25%	43%	1
Product B	27%	51%	22%	1
Product C	28%	13%	59%	1
Total Per Machine	30%	29%	41%	1

Can anyone help me, please?

Kind regards, Luiz Bisco

[sunny_talwar]

Try this may be:

Count(Measure)/Count(TOTAL <Product> Measure)

or if you are doing Sum, then this:

Sum(Measure)/Sum(TOTAL <Product> Measure)

[#3]

Thank you for the attention, Sunny!

Ok, but It will give me the % of the general not by product by machine.

[sunny_talwar]

I think it should, let me create a small sample for you

[sunny_talwar · Accepted solution]

Check this out

[#6]

Sunny, can I make it inside a set analysis.

I'm trying to do something like that, I have to show only one process:

Sum( Total {$<

Process={'Extrusion'}

>} Measure)

[sunny_talwar]

Sure, may be like this:

If you want it in both numerator and denominator

Sum({<Process = {'Extrusion'}>}Measure)/Sum(TOTAL <Product> {<Process = {'Extrusion'}>}Measure)

If you want it only in denominator

Sum(Measure)/Sum(TOTAL <Product> {<Process = {'Extrusion'}>}Measure)

[#8]

You're so smart, really! hahaha. Thank you very much!