I am trying to produce a table like this in OBIEE Answers. I am able to get product and sold column fine but how can I work out the % column.
It is basically doing % = product_sold/total * 100
A pivot table will do this automatically for you. Duplicate you measure with "Duplicate Layer" and then "Show Data As..." - "Percentage" etc like I highlighted here