Skip to Content
0

Dates how to display all months in last year

Jun 30, 2017 at 12:32 PM

35

avatar image

Hi

How can I show the last 12 months from the reporting date in the horizontal axis of a cross tab report. I need to know how to set up the months eg build a variable

Thanks Will

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

AMIT KUMAR
Jun 30, 2017 at 01:03 PM
0

how much data in your report? 12 months

for to extract month multiple ways.

for extract month name=formatdate([date];"Mmm")

for month number=formatdate([date];"MM")

Share
10 |10000 characters needed characters left characters exceeded