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