Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
i would like to show the date wise Total in my chart in a separate column
23/11/15 Total 22/11/15 total 23/11/15 - 22/11/15 total (difference)..... like that..
how i can do this? please help me on this.
thank you
HI Sowmya,
Like this you want?
Hi,
I Hope your requirement is like this,
Expression 1: Sum(Sales)
Expression 2: Sum(Sales)-Above(Sum(Sales))
PFA
Hope this helps,
Regards,
HirisH
Use Date as a Dimension
Expression: Sum(Total Sales) as Total
For Day Sales Difference: You can try above() as suggested by Hirish but it would not work for 1st value, or you can try sth like :
sum({<DateField={'=$(=date(max(DateField),'DateField Format')>} [Total Sales]) //For Current Date
-
sum({<DateField={'=$(=date(max(DateField)-1,'DateField Format')>} [Total Sales]) //For Previous Date
Hope this will help!!