Total should change only for country selection not for level selection

[#1]

Hi,

Pls find the attached qvw and data source file, What I want to achieve is:

Initial total is 10056 for 2014 year and 10058 for 2013, but when I select Country then Total mode value is changing that is fine, but my requirement is when I select Level the total should not change.

Ex: When I select AE for Country then Total for 2014 and 2013 is 248 and 1100 respectively.

The total has to change when I select Country only. How to achieve this.

I used 2014: =SUM({$<Year={2014}>} Revenue) and 2013: =SUM({$<Year={2013}>} Revenue)

Pls let me know how to achieve this.

NOTE: I use personal edition, kindly don't send qvw file.

Thanks,

[#2]

Change your expression to

sum({$<Level=,Year={2014}>Revenue)

[tresesco]

Try expressions:

SUM({$<Level=,Year={2014}>} Revenue)

SUM({$<Level=,Year={2013}>} Revenue)

[its_anandrjs]

By pass your selection for another dimensions that is Level, like

=SUM({$<Level=,Year={2014}>} Revenue)

=SUM({$<Level=,Year={2013}>} Revenue)

Hope this helps

[#5]

Thank you all, it is working as expected. Thanks,