Previous Date

[smilingjohn]

Hi All,

I have a straight table ...

Now i need to show the sum of revenue for all the months of 2017 and the first 2 rows of the Date field  at the topshould  show, 2 privios yers revenue  that is for 2015 and 2016 and then all the months of 2017 as shown in the image

how can i achieve this please find the attachment and snapshot  and the excel file

For current year ( 2017)  show the Revenue monthly wise and for previous Years (2015 and 2016) we need show the revenue as monthly avaerge.

Under date field the firts 2 rows should show previous year(2015 and 2016 )  and then current years full month

Please someone suggest me

Tahnks in advance

[antoniotiman · Accepted solution]

Hi John,

see Attachment.

Regards,

Antonio.

[smilingjohn]

Thanks Antonio

You are genius it works for me

[antoniotiman]

Thanks John,

I'm glad to helped You.

Regards,

Antonio