Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm trying to get sumproduct result as in excel file for %Sales & GM2 Target at supracategory level. In this case, for mobile phones 7.4%.
Can you please help me?
%Sales * GM2 Target doesn't work (result will be 8.9%).
Accepted Solutions
Hi,
I can't open your QVW, but think you need to look at Total Mode, so from toy app below only difference between 3rd and 4th expression in screenshot from toy application below is on the 4th Total Mode is set to Sum of Rows - which gives same as SUMPRODUCT would in Excel.
Cheers,
Chris.
sales:
Load * Inline [
Order, Product
1, X
2, X
3, X
4, Y
5, Y
6, Z
7, Z
8, Z
9, Z
10, Z
];
target:
Load * Inline [
Product, Target
X, 5%
Y, 10%
Z, 20%
];Hi,
I can't open your QVW, but think you need to look at Total Mode, so from toy app below only difference between 3rd and 4th expression in screenshot from toy application below is on the 4th Total Mode is set to Sum of Rows - which gives same as SUMPRODUCT would in Excel.
Cheers,
Chris.
sales:
Load * Inline [
Order, Product
1, X
2, X
3, X
4, Y
5, Y
6, Z
7, Z
8, Z
9, Z
10, Z
];
target:
Load * Inline [
Product, Target
X, 5%
Y, 10%
Z, 20%
];
