Relative percentages within chart dimension

[Anonymous]

This is probably really simple but i can't seem to find the solution. 

Below on chart 1 I would like each Type to be on a scale of a 100%.  If i drill down, chart 2, I get what I would like at the higher level.  I have selected "relative", and the formula is a sum of an amount that can be positive or negative.  Each negative will have a corresponding positive, so i would like the % of negatives & positives.

[goldnejea8]

The relative option shows the percent as compared across your entire dimension (type) set.

Try doing something like this:

sum(fabs(Amount))/aggr(nodistinct sum(fabs(amount)),type)

De-Select the relative option, and on the numbers tab, choose Number and select Show in Percent (%)

qlikuser14 answered this question in this post:

http://community.qlik.com/message/202415