Total without selection

[clovati]

Hi all,

I have this:

LOAD * INLINE [

    Continent, Country, Town, Revenue

    EUROPE, ITALY, Milan, 100

    EUROPE, ITALY, Turin, 200

    EUROPE, ITALY, Rome, 300

    EUROPE, ITALY, Naples, 400

    EUROPE, FRANCE, Paris, 10

    EUROPE, FRANCE, Bordeaux, 20

    EUROPE, FRANCE, Mareille, 30

];

If I create a list box for Town, I want anyway the whole TOTAL for COUNTRY and CONTINENT... how can I do?

In other words:

without selection I obtain:

And If I select just Paris, Mlan, Naples I would obtain this, with alla totale values laike having not done any selection:

Thank in advance!

[Anil_Babu_Samineni]

i am not facing any issue

[sunny_talwar · Accepted solution]

Not sure, but may be you need this (I used Anil's qvw to test this.... pfa the modified version)

=If(Dimensionality() = 3, Sum(Revenue), Sum({<Town>}Revenue))