Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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))
i am not facing any issue
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))