Hi
I need help in calculating the % by product line total. I have attached a sample XML spec. Not sure why i am getting the same result for both my % calculations.
row nesting : product line, product type.
column : 2005
measure : quantity
percentage(quantity tuple 2005 within set product_line) to get % by grand total
percentage(quantity tuple 2005 within set produce_type) - to get % by product line but
i get the same result as previous calc.
Many thanks in advance.