Hi everyone,
Now a days I am learning different ways to put set analysis.
For example,
=year(AddYears(maxOrderDate,-1)) & ' vs. ' & year(maxOrderDate) & ' ' & Only({<No={59}>} [$(=vDataLanguage)]) & ' = ' & num(( sum( {<Year={$(=Max(Year))}>} SalesAmount) - sum({<Year={$(=Max(Year)-1)}>} SalesAmount))/sum( {<Year={$(=Max(Year)-1)}>} SalesAmount), '#.#%')
Now, if anyone would be kind enough to put some more real time examples like this into the list with the explanations for the whole writing ( for what purpose anything is used in the line ). I know it's bit tedious but I wish someone would do that.
Regards,
KHARANSU
