Ciao Mackers...sorry if i disturb you again.
I tested your set but i receive an error that tell that:
i TRANSLATE from italian,...
IT IS EXPECTED A HIERARCHY EXPRESSION INSTEAD YOU DID A MEMBER EXPRESSION...
So i discover with your help , the error...
Syntax correct is without .[All Marca_Modello] ...(you could not know extacly my dimensions and their attributes ) that is...:
with set [MIs] as
Filter([Marca_Modello].[Codice Merceologia].Members
,Left([Marca_Modello].[Codice Merceologia].CurrentMember.Name,2) = "MI")
SELECT
[MIs]
ON COLUMNS,
[Measures].[Importo Venduto] ON ROWS
FROM Vendite
WHERE [Anno].[All Anno].[2012]
Sincere thankings to you... !!!!!!!!!!!!
PS. Now i know i have to use also VB Functions....with MDX...
Thanks again...
🙂