
Re: Arithmetic Operation between two diff Aggr and changing the partial sum
Jacob Neroth Jan 20, 2014 9:18 AM (in response to Jacob Neroth)Hi Nicole , i am using a pivot table and using partial sum. and the total in the partial sum is messed up

Re: Arithmetic Operation between two diff Aggr and changing the partial sum
Nicole Smith Jan 20, 2014 9:20 AM (in response to Jacob Neroth)I believe Partial Sums always use expression totals, so you'll either need to mess around with your expression until it gives you the value you want (by summing the rows), or use a straight table instead.


Re: Arithmetic Operation between two diff Aggr and changing the partial sum
Jonathan Dienst Jan 20, 2014 9:30 AM (in response to Jacob Neroth)Hi
You will need something like this (assuming Column1 is the single dimension in the table):
Sum(Aggr(
Sum(Aggr(Sum...)) * Avg(Aggr(Avg...)) / Sum(TOTAL Aggr(Avg(Aggr(...)))),
Column1))
The bold sections are your column2 and column3 expressions. All the chart dimensions need to be included in the dimensions of all 5 of the aggr() expressions.
HTH
Jonathan

Re: Re: Arithmetic Operation between two diff Aggr and changing the partial sum
Jacob Neroth Jan 20, 2014 10:41 AM (in response to Jonathan Dienst )Jonathan, i have attached an sample, it doesnt work. Sorry but do you mind helping me out here?

1234.qvw 148.0 K

Re: Arithmetic Operation between two diff Aggr and changing the partial sum
Ajay Krishnan Prabhakaran Jan 20, 2014 10:59 AM (in response to Jacob Neroth)Hey Jacob,
Why should the total of column4 be 23.3333.
per your explanation it should be (20 * 600) / 600 = 1200/600 = 20 isn't it?
Thanks
AJ

Re: Re: Re: Arithmetic Operation between two diff Aggr and changing the partial sum
Nicole Smith Jan 20, 2014 3:44 PM (in response to Jacob Neroth)Jacob,
Please see the attached. It should give you what you're looking for.
sum(aggr(sum(aggr(avg(Sales)*Sum(Target),Country))/sum(aggr(Sum(TOTAL Target),Country)),Country))

1234.qvw 148.2 K

Re: Re: Arithmetic Operation between two diff Aggr and changing the partial sum
Jacob Neroth Jan 20, 2014 6:14 PM (in response to Nicole Smith )Thanks a lot nicole


