show value as % of next door columns Total

[Arnoux]

Good day. Referring to the attached picture. I need the highlighted value (9) to show as a percentage of the other highlighted value (22550). In the values field, yoy will see that these two values are from different columns. Please Help

Kind Regards
Arnoux

I have a pivot table like this

[Arnoux]

Good day. Referring to the attached picture. I need the highlighted value (9) to show as a percentage of the other highlighted value (22550). In the values field, yoy will see that these two values are from different columns. Please Help

Kind Regards
Arnoux

I have a pivot table like this

I can add the spread sheet if needed

[Herbds7]

Needed indeed.

[Arnoux]

Here is the sample

[Herbds7]

Excel 2010 PivotTable
An easy workaround exists if you only consider one variety.
Otherwise Excel 2013 Pro Plus PowerPivot is needed, which is a bear.
http://www.mediafire.com/view/m0ltmw.../05_21_15.xlsx

[Arnoux]

Excel 2010 PivotTable
An easy workaround exists if you only consider one variety.
Otherwise Excel 2013 Pro Plus PowerPivot is needed, which is a bear.
http://www.mediafire.com/view/m0ltmw.../05_21_15.xlsx

Yeah I also got it like that, but I would like it to do the same thing through multiple varieties

I do have ProPlus powerpivot.. What is the solution in there

Thanks for the help ! I appreciate it

[Herbds7]

Excel 2013 Pro Plus with PowerPivot.
With ALL()
http://www.mediafire.com/view/qlaxz4...05_21_15c.xlsx

[Arnoux]

Excel 2013 Pro Plus with PowerPivot.
With ALL()
http://www.mediafire.com/view/qlaxz4...05_21_15c.xlsx

Thanks a lot man. This works great.

Could you perhaps explain to me what the All formula is all about haha. What is the structure of it. And how does it work. What does it do. etc.

[Herbds7]

ALL() is just one word in the DAX language.
A good introduction to DAX is given by Rob Collie in his Excel 2010 book:
"DAX Formulas For PowerPivot"
A later, more thorough book for Excel 2013 is:
"Building Data Models with PowerPivot"
by Alberto Ferrari and Marco Russo.
A possible unscalable learning curve.

[wongth7]

thanks