Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I have the following data;
Product,Category,Value
A,X,46
A,X,89
B,X,69
B,X,62
C,X,84
C,X,65
D,X,1
D,X,64
E,Y,7
E,Y,4
F,Y,87
F,Y,20
G,Y,97
G,Y,30
H,Y,24
H,Y,63
I,Y,60
I,Y,2
J,Y,19
J,Y,51
As a result I want the next table.
The share is based on the total grouped by category, but i do not want the category in the table. Every product has one category.
see the atached QV example.
Can anybody help me out here, thnx in advance!!
Hi,
Find attached with the solution. You need to use the expression below.
Sum (Value) / aggr(NODISTINCT sum(Value),Category)
Please let me know whether this issue is resolved.
Best Regards,
Sajeevan
Hi,
Find attached with the solution. You need to use the expression below.
Sum (Value) / aggr(NODISTINCT sum(Value),Category)
Please let me know whether this issue is resolved.
Best Regards,
Sajeevan
Thank you very much, this solves the problem!