PivotTable expressions with date

[alwinsch]

Hi all,

I want to create a Pivot Table, with expressions like <11/2016 ---- 11/2016 --- and 12/2016 as column headers

how can i create this, when i have the following fields:

paydate ( dd/mm/YYYY),

Amount

so i want the exact amount in the correct column when the date is correct.

Can the column headers be dynamic? when i call this report next month, the headers should look like the following:

<12/2016 --- 12/2016 --- 01/2017

thanks for your help.

Alwin

[ganeshsvm]

Yes Alwin, the solution wasn't dynamic at all, I was giving you an idea how you get the solution for your requirement.

and hope you have got the solution which you desired.

Regards,

Ganesh

[ganeshsvm]

One question on your query,

Iin the display "<11-2016", do you want to accumulate data for the previous months(from Jan to Oct) or just show sum of previous month(Oct) data?

[alwinsch]

indeed, i want to accumulate everything before < 11-2016 - i called the column "earlier then"

[ganeshsvm]

Fine, That's what I assumed earlier also from your original post where you didn't mention it and also posted my solution accordingly.

Hope you have got your solutions.

Cheers .