Reports - Aggregate function

Dear All,

I would like to have a report based on a custom date filed I have in my suite portal. Its for product expiry. I would like to know how many licenses are expiring in the next 30 days, 90 days and 180 days. It will will similar as below

[table]
[tr]
[td]Office Location[/td]
[td]Expiry (<30 days)[/td]
[td]Expiry (<90 days)[/td]
[td]Expiry (<180 days)[/td]
[/tr]
[tr]
[td]Chennai[/td]
[td]6[/td]
[td]15[/td]
[td]34[/td]
[/tr]

[tr]
[td]Trichy[/td]
[td]3[/td]
[td]12[/td]
[td]28[/td]
[/tr]
[/table]

I was able to generate the first two columns with usual conditions and fields. Not sure how to generate the next two columns. Any help on this regard would be highly helpful. Thanks

Pradeep K

I don’t know the answer, because I don’t know how your data is on the database, and what formulas you are using… but I don’t see any easy way of making multiple counts appear in different columns… it might not be possible with these reports.