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![]()
Needed indeed.
Here is the sample
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
Excel 2013 Pro Plus with PowerPivot.
With ALL()
http://www.mediafire.com/view/qlaxz4...05_21_15c.xlsx
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.
thanks
Bookmarks