Is it possible to make total conditional? For local currency i may not show the total because each country has other currency and total makes no sense, but if USD is selected total should be shown.
The situation is different, I have sales in USD for each country and Sales in Currency of the country, if i choose to see sales in USD, the total my appear, if i choose Local Currency the total may only appear if i have chosen 1 country.
example:
Szenario 1, Sales in USD for each country, no country selection, Currency Selection: USD:
Brand,Country,Sales
A1, FRANCE, $12
A2, FRANCE, $15
A2, ENGLAND, $10
Total, $37
Szenario 2, Sales in Local Currency for each country, FRANCE selected, Currency Selection: Local Curency:
Brand,Country,Sales
A1, FRANCE, 10.50
A2, FRANCE, 18.50
Total, 29 --> This is ok because only one country is selected
So far so good, but if:
Szenario 3, Sales in Local Currency for each country, no Country selection, Currency Selection: Local Curency:
A1, FRANCE, 10.5
A2, FRANCE, 18.5
A2, ENGLAND, 5.0
-->> Total, 34 that should not appear, because a total of value with different currency is useless
