Date wise totals in chart

[#1]

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

[nagarjuna_kotha]

HI Sowmya,

Like this you want?

[HirisH_V7]

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

[Anonymous]

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!!