Dividide column by Total

[#1]

Hello ,

     I am using Qv 11 .

I have 4 column in dimension side .& i want expression to divide  each value of 

column  [ total in sale]  in experrsion side by total of 1st dimension.

Dimension                   Exp

Segment                     Total in Sales                   % total

i tried it like this

     num([total in sale]  /  sum (total <segment> [total in sale] ),'#,##0')

but it dident work

pls help

[Gysbert_Wassenaar]

You can try this: num(sum([Total in Sales])/sum(total <Segment> [Total in Sales]),'#.0%')

Or you can copy the Total in Sales expression and enable the Relative option.

[#3]

sum([Total in Sales]) / sum(total [Total in Sales])

[#4]

Thank u Sir

I tried u r 1st option but it didn't work . sa per u r 2 option what is mean by "relative option" can u pls explain 

[er_mohit]

  Try this

sum(aggr(sum([ total in sale])/ sum (total [total in sale] ),segment))

and in Number tab on that expression fixed to 2 and check on %

hope it helps