How to create Filters in Reports on SaS Web Portal / SaS Web Report Studio
Data is like
Sr. No. | Group | Description | Qty | MRP | Disc | rate | GST | Total | Amount |
1 | Plate | 2M FLAT 5 PLATE GRAY | 2 | 327 | 55% | 147.15 | 18.0% | 173.64 | 347.27 |
2 | Plate | 3M FLAT 5 PLATE GRAY | 16 | 362 | 55% | 162.9 | 18.0% | 192.22 | 3075.55 |
3 | Plate | 4M FLAT 5 PLATE GRAY | 6 | 386 | 55% | 173.7 | 18.0% | 204.97 | 1229.80 |
4 | Plate | 6M FLAT 5 PLATE GRAY | 10 | 697 | 55% | 313.65 | 18.0% | 370.11 | 3701.07 |
5 | Switch | 6A SWITCH GRAY | 60 | 172 | 55% | 77.4 | 18.0% | 91.33 | 5479.92 |
6 | Indicator | INDICATOR GRAY | 10 | 263 | 55% | 118.35 | 18.0% | 139.65 | 1396.53 |
7 | Regulator | 1M FAN REGULATOR GRAY | 6 | 612 | 55% | 275.4 | 18.0% | 324.97 | 1949.83 |
8 | Socket | 6A SOKET GRAY | 25 | 294 | 55% | 147.15 | 18.0% | 173.64 | 347.27 |
9 | Socket | 1M SOCKET ( 2PIN) GRAY | 12 | 198 | 55% | 89.1 | 18.0% | 105.14 | 1261.66 |
10 | USB | USB 2.1A GRAY | 4 | 2138 | 55% | 962.1 | 18.0% | 1135.28 | 4541.11 |
11 | Switch | 6A 2WAY SWITCH GRAY | 10 | 207 | 55% | 93.15 | 18.0% | 109.92 | 1099.17 |
12 | Plate | BLANK PLATE GRAY | 6 | 50 | 55% | 22.5 | 18.0% | 26.55 | 159.30 |
13 | Switch | 16A SWITCH INDICATOR GRAY | 15 | 306 | 55% | 137.7 | 18.0% | 162.49 | 2437.29 |
14 | Socket | 16A SOCKET GRAY | 16 | 355 | 55% | 159.75 | 18.0% | 188.51 | 3016.08 |
15 | Switch | 25A DP (SPN) GRAY | 4 | 578 | 55% | 260.1 | 18.0% | 306.92 | 1227.67 |
Report must be like having Two Filters of Group & GST
Group | Switch |
GST | (All) |
Description Qty MRP Disc
6A SWITCH GRAY | 60 | 172 | 0.55 |
6A 2WAY SWITCH GRAY | 10 | 207 | 0.55 |
16A SWITCH INDICATOR GRAY | 15 | 306 | 0.55 |
25A DP (SPN) GRAY | 4 | 578 | 0.55 |
A filter won't remove columns from the object. It only filters the rows.
For the Group, you can easily create a filter on a category. Will the filter be static or will it be prompted so that users can select the group that they want?
For the GST, this appears to be a measure. In this case, a filter will normally be something like an EQUAL TO or a LESS THAN or GREATER THAN, etc. How were you thinking to filter for GST?
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Tricks for SAS Visual Analytics Report Builders
SAS Visual Analytics Learning Center
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.