Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
sum([Total in Sales]) / sum(total [Total in Sales])
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
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