Hello,
I have two different subjects,
First one : I'm using following filter
Year(transaction_date)&'-s'&week(transaction_date) this filter state name is 'Etat1'
In a pivot table I'm using those filters from 'Etat1' to get values accordingly to user selection, it works fine, however we want to display as column label the user's selection. Like this :
=GetFieldSelections(shop_name,',',5,'Etat1') & '
'
& GetFieldSelections(Year(transaction_date)&'-s'&week(transaction_date),',',5,'Etat1')
So when user selects a shop it is displayed ok, but when user selects a Year/Week we don't display it, what is correct format to display this information ?
Second question quite similar : We are using function TOTAL, with simple variable name like below it works fine, extract :
Count(total <shop_name> Distinct If(transaction_type = [...]
But again what if we want to include variables altered with functions like following :
Count(total <shop_name, Year(transaction_date)> Distinct If(transaction_type = [...]
Thanks very much for your help and time, I've digged through documentation and relative posts about set analysis, but haven't been able to solve this two issues for now..
Regards
