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