Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Team,
Below is the raw data and need to export the data to excel in one shot based on below selections.
1) Select Date='1/3/2020' and Rep Filter='Y' in list box (Will get two rows i.e ID 3,5 )
2)Select Date='1/3/2020',Rep Filter='N' and Report ='C' in list box (Will get one row i.e ID 4)
We need to export above data to excel in one shot. As of now we are doing two times export and merging the point No 1 and 2.
Date | Report | Rep Filter | ID |
1/1/2020 | A | Y | 1 |
1/2/2020 | B | N | 2 |
1/3/2020 | C | Y | 3 |
1/3/2020
| C | N | 4 |
1/3/2020 | E | Y | 5 |
Results:
Date | Report | Rep Filter | ID |
1/3/2020 | C | Y | 3 |
1/3/2020 | C | N | 4 |
1/3/2020 | E | Y | 5 |
It would likely be most helpful if you attach the QVW file on this one, so folks can see the data model and chart with expressions etc. to try to come up with best approach for the solution.
Regards,
Brett