How to fix the result even though you filter

[Anonymous]

Hi, QV community

I have a question but I am not it is possible to make it work the way I want it to work.

I will give you a example to understand what my question is about.

Say that you are spend only money on clothes, coffee and food in one year.

You have a budget for each category.

You want know to how much you spend relative of your budget in every month.

For example you want know how much you are spending percent of your budget in April in Food.

Butt my question is can I filter to two categories but still have the same percent numbers.

For example I have 2,13% of my yearly clothes' budget spent in April, 5,80% of my yearly Food's budget spent in April and 4,71% of my yearly coffee's budget spent in April.

But now only want to look at Food and Coffee and compare them to each other.

But I only want to look at the two categories but not change the percent numbers.

Anybody have any suggestions?

regards Darri

[swuehl]

I don't fully understand your attached sample file, as it seems to be missing budget data.

In general, I think you can achieve what I think you want if you disable the relative check box on chart properties and calculate the percentages in your expression, using the TOTAL qualifier in your aggregation functions and maybe additional set analysis. Please check attached.

[Anonymous]

Hi, swuehl

your answer was helpful.

this is almost what I am looking for.

The percent are the same when I filter the data.

But if I want to filter the data more.

Like if I want to look only two categories but not all three categories.

Can I do it and have the same percentage numbers

regards Darri