always last 6 months

[soniasweety]

Hi All,

I have an requirement like...

I have data for all years    so  I want to display   by default  max year selected   and

if I select any year and any month    the straight table should display previous 6months of selected month.

attached sample  and excel data

[sunny_talwar]

You want this in straight table only? Or can we use Pivot table?

[soniasweety]

anything is fine sunny

[Anil_Babu_Samineni]

How about this?

Sum({<MonthNo = {">=$(=Max(MonthNo-6)) <=$(=Max(MonthNo))"}>} Sales)

[sunny_talwar]

Check attached may be

[soniasweety]

here one more thing  I need to every month .....not totals each month  product category wise I need to show.

[soniasweety]

like below image  I need to display last six month by  product category wise.

[soniasweety]

yes sunny ... but here when I open the application  max year should be by default  it is not showing any default value

and

can you explain the logic how its working ...if you don't mind..!!!!!!!1

[Anil_Babu_Samineni]

Seems working

[Anil_Babu_Samineni]

You need to assign trigger. OnOpen - Actions - Select in field - Year - Search string (=Max(Year))