Hi Mohit
I want to explain this bit more.
I am using valuelist in my dimension for grouping purpose. It is as below.
ValueList('Direct Income','Direct Expense','Gross Profit','Other Expense','Profit Before Other Income','Other Income','Net Profit')
So in my expression I am using as below.
if
(
ValueList('Direct Income','Direct Expense','Gross Profit','Other Expense','Profit Before Other Income','Other Income','Net Profit')='Direct Income' ,
sum({<Year={'$(=vPYear)'},Period={'=$(=vMaxMonth)'}>}Amount))
but it doesn't seems to work.
Harsh
