Adding Date day wise up to month end in Pivot

[khasimvali85]

Hi Community,

I hope you are doing well.

I have facing to create the date to add daily in chart for month.

I have Date field with sales data with Branch and i want achieve in pivot chart , show branch wise data with month start date to end date.

Ex:  Branch | ASCName|  01/04/2016 |  02/04/2016 | 03/04/2016 | 04/04/2016|  05/04/2016   06/04/2016  07/04/2016|  08/04/2016| ....... up to end of the month and its every day add side by side up to month end.

Regards,

Khasim.

[mightyqlikers]

hi,

add branch, year , month, day as dimension in pivot table and sum(sales) as expression.

and in presentation table  enable check box always fully expand ,

now drag and drop year dimension on top of expression like wise for month  and day.

$@M.

[tresesco]

May be using Crosstable()?  Could you share a sample data set?

[khasimvali85]

Hi Sam,

Thanks for reply,

only add days staring to current date in pivot

[khasimvali85]

Hi Treseco,

Thanks for Reply,

I have attached Rawdata in excel file with required format please check.

[mightyqlikers]

FYI,

$@M.

[khasimvali85]

Hi Sam,

Thanks for the suggestion, my requirement is same like that,

but i have last 5 years of data and it will show you last 5 years dates as you designed way.

i want only one month i.e current month starting date to current date

Regards,

Khasim.

[mightyqlikers]

create year and month for the date feld in the back end

and use them as dimension as i have mentioned in the previus post.

$@M.

[khasimvali85 · Accepted solution]

Hi Sam,

Thanks Sam I am found the solution for this.

Created Variables  vStartDate and vMaxDate used in expressions like:

SUM(< { '>=$(vStartDate) <= $(vAMCDate)' } >}  Sales)  and use the date field in Dimension as you said.

Regards,

Khasim.

[sunny_talwar]

If you got what you were looking for, I would suggest closing the thread by marking correct and helpful answers.

Best,

Sunny