Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I have the table with such values:
Client Item_Number Quantity
Alex A 5
Alex B 1
Alex ZZ 3
John A 4
I need to get for each client total quantity of each item, but I have situation where item A and B actually are the same and I need sum them together.
As the result I need to get table, (B and A are summed together and name is changed to B)
Client Item_Number Quantity
Alex B 6
Alex ZZ 3
John AB 4
What would be the good solution for this problem?
Thank you in advance!
try to make calculated dimension
if (match (itemnumber,'A','B'),'AB',itemnumber)
it will help you