Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I am preparing a dashboard for compare profit and loss for this year vs last year.Depend on the year selection I want to display current period and last year same period in the other column but it doesn't seems to work.
Can someone give me a hand on this?
Thank you
Harsh
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
Thanks a lot
It is working for the above.