Set analysis with custom filter from alternate state and total aggr
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 :
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 :
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..