Problem with porcentual function in hierarchy
I have a issue in bex query designer with a porcentual function. I attached an example of what I need, what I need is a percentage based on the total of each group of the hierarchy (0MATERIAL) and not on the overall total:
I test with %CT and %GT functions, but booth works with the total general, and not with total group...
Y need the values of the column "MIX (value OK group material" and not the values of the column "MIX (error)".
MIX (value OK, group material)
Group Materials "X"
Group Materials "Y"
Any idea to solve this?