Hi,
I have below urgent requirements, Please help me.
Requirement1
| TRevenue | TMargin | TMargin% |
|---|
| 32,393 | 17529 | 54% |
| 23,145 | 12,258 | 47% |
| 22,735 | 8,175 | 36% |
| Some Data | Some Data | 37% |
| Some Data | Some Data | 36% |
| Some Data | Some Data | 54% |
| Some Data | Some Data | 100% |
| Some Data | Some Data | 45% |
Here i want to add two filters using multiboxes TMargin%< and TMargin%>
-->Drop down values in T Margin % < filters should be 5, 10, 15, 20, 25.
-->Drop down values in T Margin % > filters should be 75, 80, 85, 90, 95.
-->Also there should be an option to view all values in the report. That is not applying any of the above two filters
Requirement2:
I have a table like below
| Contarct No | GLDate |
|---|
| 111 | 20160831 |
| 112 | 20160808 |
| 113 | 20160804 |
| 114 | 20160808 |
| 115 | 20160809 |
| 116 | 20160605 |
| 117 | 20160409 |
I want to adda a filter using multibox on ‘GLDate’. The drop down values should be > 2Weeks, > 1 Month and > 2 Months. GL Date should be compared with today’s date to identify whether it is > 2 weeks or > 1 month etc.
Can anybody help me regarding these requirements.
Thanks,
Rajasekhar
