Hi,
I am trying to get a percentage of a measure by dividing the value got with the filter and with out the filter.
segment can-name gender count
corp a m 1
corp b f 1
corp c f 1
corp d f 1
corp e m 1
corp f m 1
corp g f 1
corp h m 1
corp i f 1
corp j m 1
corp k m 1
HR l m 1
HR m m 1
HR n f 1
HR o m 1
HR p f 1
HR q m 1
HR s m 1
HR t m 1
HR v m 1
HR w f 1
Now if if say Percentage ([sale Price], for (gender='f')) OR some other expression
i shoud get
segment percentage
Corp 45%
HR 30%
corp 45 % because there are 45% of the female among the total candidates under the segment 'Corp'
Thanks in advance...