Hi, maybe someone can help me figure out how to aggregate this
I have two ratios:
A B
Doc A Pos 1 1000 123
Doc A Pos 2 1000 233
Doc A Pos 3 1000 344
Doc B Pos 1 2000 123
Doc B Pos 2 2000 233
Ratio A is fixed along all the position of a document, while ratio B is standard.
If I remove position, at doc level I should aggregate normally B, while ratio A should show the fix value. However for upper levels, if I remove document, ratio A should aggregate normally, summing one occasion of the fixed value A for each document.
Any ideas?
Thanks