aggr help

[#1]

Hi all,

i have an issue (attached)

2 bases with 3 common dimension names and i need in a table, which i use another dimension, to put a sumprod (of each item) between 2 other dimensions - Value1 & Value2 named in the example attached.

can anyone help please?

Thanks in advance!

Cosmin

[sunny_talwar]

Are you trying to get this?

Used Sum(Value1*Value2) in a pivot table with Department and Year as dimension

[#3]

i reattached the excel source and it have also the results which i need (please reload it, i edited the figures a little bit, there where identical)

thank you!

[Anonymous]

like this?? didn't reload the latest data, but got the output you need. you can reload.

[#5]

please give the expression as text in message, i use the free version

thanks

[Anonymous]

create a pivot table with Department as row dimension nd year as column dimension.

Use expression = sum(value1*Value2).

Go to presentation and check partial sums for both Department and Year.

Will result in below.

[#7]

please reload my last excel..there are the results too

it doesn't work sum(value1*value2)

for B-2017 has to be 100 in your table, but pls reload the last excel.

many thanks!

[#8]

with this works when i select an item ..C for example but if there is no selection it doesn't work properly

=sum(aggr(sum({<Year={'2017'}>}Value1*Value2), ID))