Could I dynamically change cell value? I managed to achieve a situation where I have a weight for each and every record in the de-pivoted data table. The weights were calculated so that they add to 521 (number of respondents in our data source). I managed to create a dummy column in which I sum the number of respondents (I get 521) and then I divide each weight per 521 (to make my weights sum to 100). The problem starts when i would like to filter out a part of data for example female or male respondents. What I get in the chart is a percentage of all respondents who answered this questions and are male or female. What I would like to get is a pecentage of male or female who answered this question. Is it possible to dynamically change the sum of weights I would like to divide it for?

For example: If I would like to see only Male's answer to question Q2 I need to sum the weights of all male respondents (lets call it X) and divide the sum of weights of male respondents who answered this question per X (not per 512 cause I filtered out all the female respondents and my overall number of respondents is less now), so that I get the right percentage. Is it doable at all?

I enclose the screen shots of sample calculation in Excel and Omniscope and the Omniscope file I created.
In total, the weights in Excel and Omniscope are the same: After filtering I get different results due to the fact that in Omniscope I cant divide the weights by only the filtered sum of weights whereas it is really easy in Excel.