Ignore the current selection on Straight Table

[#1]

Hi,

Please consider the following situation:

In Table 1 I have a customer list with has a metric to calculate the Sum of quantities ordered (showed as a top) based on YTD flag. In same table I’m calculating the customer ratio in percentage based on the expression

=sum(QuantidadeKG)/sum({TOTAL <[MonthYear]> QuantidadeKG).

In table 2 I have the comparison in the homologous for the same metric and also with the ratio column in percentage and two other columns for variance percentage.

The expected result is to show in Table 2 the overall ratio percentage as showed in Table 1 ignoring the selections I made on Table 2.

Example:

If customer 5018270000 has 60.60% in Table 1, I want to show that value also in Table 2 to never lose the overall % ratio and relevance information of the customer, independent of the selections I made on the other table.

Tables before selection:

    Table 1                                                     Table 2

Tables after selection:

After the selection in table 2 the ratio is being calculated based on the metric instead of the overall ratio as showed in table 1.

How can I get the correct result in the table 2?

Please find attach a qvw and sample data file.

Many Thanks

Paulo

[swuehl · Accepted solution]

change your perc expression to

=Sum(QuantidadeKG)/Sum({1}TOTAL <[MonthYear]>QuantidadeKG)

and disable the realtive option for that expression

[#3]

Perfect.

many thanks swuehl