OBIEE Analysis Query

Adz10

Hi,

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

   

Product	Sold	%
A	50	55.56
B	25	27.78
C	10	11.11
D	5	5.56
Total	90

Thanks

[Deleted User]

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