Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I need your help,
I have some troubles with an expression using set analysis and a variable too.
This is my exprssion in a pivot table :
sum({$ <{$(vAndSubFamily)$(vNotSubFamily)}, Type = 'Actuals' >} [Amount])
$(vAndSubFamily)$(vNotSubFamily) are two succesive products choices
Actuals is a filter on the Sales Type , I have other Types like Budget and Quotations.
Do you know where the error comes from ?
Thank you,
Have a nice day,
David
Hi,
Yes I use excatly your expression and still doesn't works.
Please find here a sample,
The Customer pivot uses your expression.
Regards
David
Hi Try this,
=sum({$ <SubFamily={'$(=vAndSubFamily)','$(=vNotSubFamily)'}, Type = {'Actuals'}>} [Amount])
If you have created variables in variable wizard then put = in the begining of defination.
Regards
KC
Check your variables, they are not producing expected output.
yes there is no proper o/p in your variables.
Regards
ASHFAQ
Hi,
Sorry, but I don't understand what you mentioned,
Can you give me an example please ?
Regards
David
Hi KC,
thanks for your proposition but still not working,
the problem is from elsewhere apparently
Regards,
David
Hi,
have a look at attached image.
Regards
ASHFAQ
Hi David,
Please check your variable 'vAndSubFamily' and 'vNotSubFamily' here when I check these variable in text box then in first variable gives output '$Field' and second gives no data.
Thanks
Hi Dhiraj,
Thanks for your post,
I tried that but still not working :
vNotSubFamily :
=if(count({NOT} distinct SubFamily)<>count({NOT<SubFamily>} distinct SubFamily), //some products selected (but not all) '*' & concat({$*NOT} distinct '<' & vRelevantField & '=E({<SubFamily={' & chr(39) & SubFamily & chr(39) & '}>} ' & vRelevantField & ')>','*',SubFamily), ' <$Field>')
Regards David
ASHFAQ,
Sorry for my bad level ....
I tried that but still not working :
vNotSubFamily :
=if(count({NOT} distinct SubFamily)<>count({NOT<SubFamily>} distinct SubFamily), //some products selected (but not all) '*' & concat({$*NOT} distinct '<' & vRelevantField & '=E({<SubFamily={' & chr(39) & SubFamily & chr(39) & '}>} ' & vRelevantField & ')>','*',SubFamily), ' <$Field>')
Regards
David