Results 1 to 10 of 10

Thread: show value as % of next door columns Total

  1. #1

    show value as % of next door columns Total



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	HELP.jpg 
Views:	69 
Size:	100.3 KB 
ID:	3525  

  2. #2
    Quote Originally Posted by Arnoux View Post
    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

  3. #3
    Needed indeed.

  4. #4
    Here is the sample
    Attached Files Attached Files

  5. #5
    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

  6. #6
    Quote Originally Posted by Herbds7 View Post
    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

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

  8. #8
    Quote Originally Posted by Herbds7 View Post
    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.

  9. #9
    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.

  10. #10

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •