Skip to Content
0
Former Member
Jan 16, 2012 at 09:49 PM

BEx Query: Percent Share based on characteristic

336 Views

My question is around a query that follows this sort of layout:

Order  |  Doc No.  |  Account  |  Type  |  *Amount*
   1            1          1          A         20
   1            1          2          A         30
   1            2          3          A         40
   2            3          4          A         50

I want to calculate the percent share by Doc No. so in this example, I'd want it to show like this:

Order  |  Doc No.  |  Account  |  Type  |  *Amount*  |  *Percent*
   1            1          1          A          20         40% 
   1            1          2          A          30         60%
   1            2          3          A          40        100% 
   2            3          4          A          50        100%

I've tried doing a forumla based on amount with Aggregation of summation on Doc No. and that didn't work. I also tried some of the other percent functions but unless the exact doc no. is drilled down on, they show the percent share for the entire report which doesn't work either. Any ideas? I feel like I've done something like this before but can't seem to get it to work! Points to an answer that yields the result I'm looking for!

Thanks!

Edited by: Christopher Deaner on Jan 16, 2012 10:55 PM